Formula to check a box when date entered + 2 days

dplunkett79331 · 2019-09-09 20:13:05

Does anyone know if it is possibly to set a box to check a certain amount of time after a date is imputed into a row. For instance, we need a lag time on a project complete date of 48 hours. This is for a manufacturer that needs 48 hours for stain, etc to cure before project is technically complete. This is the formula…

Comments

Andrée Starå Community Champion

01/31/20

@Peggy P
Excellent!
Happy to help!

SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E: andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
0 · Share on Facebook Share on Twitter
Paul Newcome Community Champion

01/31/20

@Peggy P Happy to help! 👍️

CERTIFIED SMARTSHEET PLATINUM PARTNER
10x Time Savers (An exclusive group that grants you access our Smartsheet master classes, tips, tricks, & much more!)
Would you benefit from getting my help in person?
0 · Share on Facebook Share on Twitter

Try for free

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Trending in Formulas and Functions

Different way to track health
I have a project without a set end date and am being monitored on if I am getting it closer to completion by the % complete field, how can I make a formula that tracks health based on that forward pro…
Answered ✓
Formulas
Project Management
Formulas and Functions
36
4:55 pm
6
Index Collect Contains Multi Dropdown and Text String
I am trying to pull a Name based on 2 criteria in 1 sheet into another sheet: Assigned References: {Name} - Sheet 1 {Role} - Sheet 1 - Two Options; Primary and Liaison {Client Assignment} - Sheet 1 (i…
Answered ✓
Formulas and Functions
18
1:46 pm
2
Report Not Showing the Correct Information on Dashboard
I am embedding a report onto a dashboard. The user that should have information displayed to them has permissions on the source sheet, report and dashboard. Even when I click into the report with the …
Answered ✓
Reports
Dashboards
current user
Formulas and Functions
19
2:01 pm
2

Formulas and Functions

Formulas and Functions

Formula to check a box when date entered + 2 days

Comments

Help Article Resources

Quick Links

Categories

Trending in Formulas and Functions

Different way to track health

Index Collect Contains Multi Dropdown and Text String

Report Not Showing the Correct Information on Dashboard