So, this is a SharePoint question, but I thought someone here may know the answer. Can anyone tell me how to write a formula in a date field validation to restrict responses to a date after a certain date? Say, I wanted to only allow dates after 07/05/2020. Google and YouTube failed me.

like
Posting as :
works at
You are currently posting as works at

Related Posts

Please add “spuddle” task code to IntApp thx

Post Photo
likefunny

Anyone have any R&D contacts for cookie or chips product development? Looking for a white label solution we can modify for a product extension. Thanks

like

Art Directors, how do you feel being led by creatives with copywriting background (CDs) whose present clearly lack of knowledge about Design/Art Direction references. How to deal with it? Any tips?

like

Are most of people in this bowl from a science background or coming from a finance/impact investing perspective?

Does anyone work at Ferrari corporate? Long shot but looking for a referral 😅

likeuplifting

Your favorite Denver agencies?

Anyone else find it strange that Slack and Company has advised their employees that they are shutting the agency down on Friday, yet they still have available positions showing up online.

Do you bill the client for your time during lunch recess for court?

like

Left a great job for higher pay. Absolutely hate the new. Has anyone gone back to their old employer? I was a very good employee, respected, and dependable. It’s only been two weeks but the new is horrendous 😩

like

Looking for places that are not freezing in late March. Immunocompromised Toddler has been stuck in home all time and would like her to explore outdoors. We live in Columbus Ohio so any trips with in 8 hour drive and planning for a week. Thinking smokies and Knoxville but open for other ideas

likehelpful

I need to get out of a toxic relationship. I don’t have a car. I feel stuck like that scene from Maid. I’m pre-approved and have a small down payment saved. I just need to do it. What should I be thinking about to stay positive?

like

Any great resources or tool recommendations to learn financial modeling? I have a cpa so acquainted with financials as a whole. Thank you!!

like

Does anyone have insight to Motto, branding agency?

I am membership director for a medical based fitness facility on the west side. We offer corporate partnerships. I would love to network with companies in Indianapolis!

likeuplifting

What do I need to know attempting to transition into Tech? Currently active duty military, working acquisitions as an engineer (I don’t do engineering) but I will be transitioning soon to the civilian work force and would like to get into tech. Any advice for the transition or things to watch out for/keep in mind. I’m looking at technical project management, engineering management, or product management as examples of roles. 5 yoe in mil.

like
likesmart

Any agencies in NYC looking for freelance APs?

Interested to connect and discuss how to land a first job with internship experience and an MBA

like

I am currently a year from finishing my PhD and was looking at VC's as a career path because I like to do meta-analysis of different climate change techs. I networked with VCs and one of them was receptive but didn't have the budget currently for a full time hire. They said they'd be interested in working with me to do a research paper over the coming semester, and was wondering if I could leverage this into a full time offer?

Is a white paper with a VC going to be attractive on my CV?

anybody has an idea of High-level home construction cost estimates. Say $400 per sqft on an avaerge in peninsula vs $300/sqft in east bay?

like

Additional Posts in Excel Genius

How do I stop excel from changing the cell reference to a different column each time I refresh the data pull?
The spreadsheet is connected to an API data pull. Each time I refresh the data it changes the cell reference (SCD_0010) to a different cell e.g. (SCD_0127). How can I stop this?

Post Photo
like

Can I write a macro that will fill out a table of information based on cells that have comments on them? For example, if G12 has a comment, I want to pull text from that comment + data in A12.

like

Is there a way to consolidate non numerical data from multiple excel sheets into one master sheet?

like

Why when I refresh a query, the table where the query is loaded to just gets duplicate rows? Same with the pivot table that feeds off of that query?

like

Is there any easy way to handle FedEx/ups tracking numbers? I’d like to have some formula that would just show the status in another cell.

like

Best pdf to excel converter?

like

I want to create a heat map of when people are unavailable with day of week as the columns and hour of day as the rows. I have start times and end times, how can I use this data to create the map?

like

I’m trying to go back to the basics. How do you guys structure thoughts around identifying the correlation between 2 variables? A basic example: the number of steps I take in a day and the hours of sleep I got that night.

like

A lot of the work at my new employer is quite redundant and can be automated via macros. What are some of the best resources to learn vba?

like

Need some help. Is there a fax function (Filter) so that if I want my subtotals to show a number but nothing below it to report. One expansion of a row the subtotals show but no numbers below it.

like

Just created my first macro! Super proud of myself! #humblebrag

likeuplifting

How do you all prepare for excel/financial modeling tests? Every firm is different, so I imagine there are multiple effective ways to get ready.

likehelpful

Last cell question. Some of my simple models are massive in file size because every tab has a last cell of ~XFD65. But I’m not using anything past ~U100. Continued.

like

What are the most typical models you all build

likehelpful

Is Macabacus or any other add-in actually worth it for Excel & PPT? In LMM - MM M&A roles.

likehelpful

Has anyone encountered this error before? We can’t access a workpaper with 70% of the work done 😩😩

Post Photo
like

Ok, using excel is not a primary function for my role (this will be very obvious shortly...) So please be kind! On my sheet, in the first and third columns, I have lists of reference numbers. In the second column I have a client name. I already identified the duplicates in the first and third columns using conditional formatting.What I need to find now is column 2 value, whenever value in column 3 is identified as duplicate. Problem is, I have over 120k rows of data so I can't filter! Help!

like

Hi team i have a bit of doubt.
I have an excel sheet where column A is the order numbers. I want to add comments in column G.
There are many repetitions in order numbers but they are all sorted in ascending so all the repetitions are below one another.

If i have a comment, how can i automatically paste that same comment in all the repetitions of that order numbers if i write it in the 1st instance.

Thanks in advance

like

What are your top Excel ninja tricks? Ones that few people know...

like

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
That was just a preview…
Sign Up to see all discussions
  • Discover what it’s like to work at companies from real professionals
  • Get candid advice from people in your field in a safe space
  • Chat and network with other professionals in your field
Sign up in seconds to unlock all discussions on Fishbowl.

Already a user?
Login here

Share

Embed this post

Copy and paste embed code on your site

Preview

Download the
Fishbowl app

See what’s happening in your industry
from the palm of your hand.

A phone with Fishbowl app

Send download link to your phone

OR

Scan your QR code to download
Fishbowl app on your mobile

By continuing you agree to Terms of Use and Privacy Policy.

Messaging rates may apply

Download app

Sign up for free to view this conversation on Fishbowl

By continuing you agree to Terms of Use and Privacy Policy

Already have an account? Log in

Sign up for free to continue using Fishbowl

By continuing you agree to Terms of Use(New) and Privacy Policy(New)
Messaging rates may apply

Already have an account? Log in

For account settings, visit Fishbowl on Desktop Browser or

General

Legal