Does anyone have a formula to calculate the date 90 days from current date?
Current Date Next Due
02/09/2022 (formula to display) 05/09/2022
Have you checked this article?
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.