Formula help
From my sheet I need to populate a checkbox based on these criteria
VDate is less than WDate
AND
Status = Live
This formula is working to accomplish the first criteria but I can't get the status part to work.
=IF([VDate]@row < [WDate]@row, 1)
Thanks for the help, I am horrible at formulas!
Best Answers
Answers
-
-
Hi @Ruth Schoonover,
Give this a try, and let me know if it works for you:
=IF(AND(Status@row = "Live", VDate@row < WDate@row), true, "")
Please make sure the column properties where you have this formula is set to "Column Type: Checkbox"
https://www.linkedin.com/in/zchrispalmer/
-
I am getting an unparseable error on that formula.
-
-
New to Smartsheet ..... looking for the formula to calculate what the finish date would be based on inserting "start date" and "Number of Days"
-
Hi @Mark Boxley
If you aren't looking at "working days", then you can simply use the + symbol to add your number to the Date and it will return another date:
=[Start Date]@row + [Number of Days]@row
See: Use Formulas to Perform Calculations With Dates
If you need to exclude weekends, then you can use the WORKDAY function:
=WORKDAY([Start Date]@row, [Number of Days]@row)
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 430 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!