Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template to view 100+ formulas, including a glossary of every function and examples of commonly used and advanced formulas.

Product questions?
Ask it here! The community's got your back.

Formulas and Functions

Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

Security Options about 3rd Party Supplier
I am using Business Plan on smartsheet.I would like to learn that if i will share one sheet with 3rd supplier , is it possible that this 3rd party supplier could reach to another sheets on my account, or 3rd party supplier will be able to reach only the sheet that i shared.I ask his question to understand the privacy…
Need Formula Help
Hi Dear Community ; I am new about smartsheet so i would like to get your kind supports i need a formula like that ; i have a sheet as below with column names , in my scenerio i am getting datas with forms from last users , for example when the last user choosed the "Status" Column as "completed" , i want that the date of…
Latest Date in a column
I have set up an automation to set the last updated date in a column on a project plan. I want a formula that will reference the project plan last updated column to show the last date the project plan was updated. I am using the following formula: =MAX({Project Plan Range 1}:{Project Plan Range 1}) I'm getting a…
Static Date/Time Stamp
I've looked around and I realize that this is a feature many people want within smartsheet. I was wondering if anyone has a workaround for this. I want to automate the start date to today but I don't want it to change so using =TODAY () won't work. The sheet that I'm trying to implement this in also uses a form to input…
Date Stamp
Over the past couple of days, I have searched and read every article and even solicited help from SS and have worked myself in a circle. I have a drop-down list (Submitted, Approved, Declined), I need to "auto-populate" a date column to capture the date stamp when something is selected from the drop-down list. Is this…
How do I automatically add a date and time stamp to a form?
I want to set this up as a hidden field to populate the date and time each time a user populates the form. I do not want users to fill in the date and time.
Is there a way to set up a time stamp while utilizing the workflow automation? Thank you!
I know I can create a column for a "Modified Date" or a "Modified By"; but will these columns work properly if I am using the workflow automation on my sheet? Thank you!
Duration formula
I am using one of the PM templates while adding in additional columns for actual start dates and actual finish dates. As such, somewhere I have lost the duration formula in that column. Can someone please help me with the formula that would determine the work days for planned start and planned finish minus weekends? Thank…
Populate a cell with today's date when status is marked complete
Hi all, We have several task schedules that people use to track the status of their work. When the task is finished, they change the Status to Complete and the Percent Complete to 100%. We would also like to know the actual date the work was completed to compare it to the Due Date (which is referenced from another cell in…
Keeping Track of Completion Dates and Updating Status
I am relatively new to using Smartsheet, but here is what I'd like to be able to do. I have a Course Development Tracker sheet that lists courses to be developed in the next term. My team has a 60 day development process, with 5 checkpoints. Each checkpoint should be met by a certain number of days from the due date. CP#1:…

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Popular Tags

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

NEED TO ADD DAYS TO THIS FORMULA IF ANOTHER CELL HAS SPECIFIC ITEMS OF A DROP DOWN.
I have this formula that works for this cell when information is missing from reference cell A. However now we want to be able to add additional days if reference cell B has specific items checked in a dropdown. I just can't seem to get it to work. Any suggestions. =IF(ISBLANK([ ENGINEER (tentative start date)]@row), "",…
Check a Box if Between Dates on Another Sheet
Hey all, I am trying to build a formula to check off a box on my sheet if at least one date is found between two dates on a separate sheet. I've tried a million variations but here's what I have so far, thinking I was overcomplicating things =COUNTIFS({Approve Date}, >=[Week Starts]@row, {Approve Date}, <=[Week Ends]@row,…
How to Automatically Checkmark a Column for entries that are created within a time-based timeframe
I'm trying to write a formula that will automatically place a checkmark in a checkbox column titled "Today Entry" whenever entries meet the "Created" column criteria of being submitted after 1100 AM the day prior and 0800 AM today on a rolling basis: I've been trying to use the below column, but honestly I have no idea. I…

Formulas and Functions

Discussion List

Help Article Resources

Categories

Popular Tags