I am trying to put together a formula that says: " If the Renewal Alert Date is blank, change column to 30 days"
Hi @Brittany Marie
I hope you're well and safe!
Do you mean it should change to the text "30 days" or add 30 days to a date?
I hope that helps!
Be safe and have a fantastic week!
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Thanks for getting back to me, so I want to create 30 days to date
Right now I have a date in the Renewal End Date column that will populate a date that is 45 days before the contract end date.
=[Contract End Date]@row - 45
So, I need help adding to this formula that says if the Contract End Date column is blank change the date to 30 days out from the Contract Start Date . But, had some issues whether I should use Ifs or if blank function
Create and edit formulas in Smartsheet
Formula combinations for cross sheet references
Smartsheet functions list
Hi everyone, I have one of those pesky formulas that is giving me a hard time. This is for a Summary Sheet I'll use to build a dashboard so I'm referencing another sheet with the data. Here's what I am trying to pull...Count if the following is true: 1) Project name is the same as the project in the summary sheet 2) Month…
Hi There I am using the below formula to check a box if a date is one day greater than today. The formula works fine except if the date field is blank, then it is showing up #Invalid Data Type. How can the results show up as blank instead of #Invalid Data Type if there is no date referenced yet? =IF(NETDAYS([Date to…
I have an intake form where we receive campaign budgets. We are trying to track when our campaigns as a whole start spending over our expected Overall Budget. I need a column formula that can calculate the remaining budget when a new campaign is added. Currently, the intake form is set up to have new campaigns be added at…
©2024. All Rights Reserved Smartsheet Inc.