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.

CountIF with multiple Criteria
This discussion was created from comments split from: CountIF with multiple Criteria.
Automation randomly Unable to run due to infinite loop
I have an automation that randomly becomes unable to run. "This workflow triggered itself directly or through another workflow. Please modify the workflow so it doesn't cause an infinite loop.". Any ideas of what might cause this?
VLOOKUP with concatenate
My project has a "master project" sheet and then dozens of individual project sheets. On the mast project spreadsheet, people will enter 3 letter customer mnemonics [Organization] and select from a drop down list in [Project}. The drop down list could be a single or multiple from that list. The primary column is a…
Reoccurring Calendar Dates
I think this is quite complicated so i will try and make it as simple as possible. There is a date when a site goes live {Go Live Date}, when one of those dates are imputed I want it to automatically be added to a calendar for annual maintenance which is based off the go live date. Then i want it to automatically roll over…
Pulling just the date from a cell
Hi! I think my question is pretty simple. On a sheet, I have two columns. One is "Primary", and it's blank. The other is "Created" - a date/time column that auto-populates from a form. I want the primary cell to only pull the date from the Created column. I've tried a few different formulas with no luck. Anyone have any…
Military Time
I have a form populating a sheet. I need to know what HOUR (in military time, 00-24) each row was added so I can count the ones that came in outside of business hours. Can anyone assist?
Dynamic Cross-Sheet Reference to Schedules from Master Tracking
We have a Master Tracking sheet with Project Names and we rollup data from individual schedules named (Project Name)_Schedule. In the Master Tracking sheet, I would like a cross sheet reference created to the schedule without having to manually create them. Is there a way to do a column formula that takes the Project Name,…
Setting Formula to Remain it's Current Value Unless Told to Change
So I am trying to set up custom baseline formulas for our PMs and am attempting to have the baseline date change to the actual when a checkbox is ticked and then it is to remain that value when the checkbox is unticked and not automatically update with the actual dates any further if changes are made to it. Here's the…
Smartsheet automation not triggering when cell is updated from Form.
I’m creating a sheet and am having issues with automations not triggering when cells are updated from a form. The automations work when you manually update the cell on the sheet but not when the cell is updated via a form. It also won't record a date when the cell is updated via a form. Any assistance would be greatly…
User in cell
Hi, Does a formula exist to extract the active user and add it to the cell for a column formula ? Best regards

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

Netdays calculation with optionnal date column
Hi i'm looking for a formula to calculate the netdays between 2 dates. but i have 3 dates in the equation. a date column (date 1) whit references from another sheet and a manual one (date 2) to overwrite the first one. the third date is the "today" date (date 3). so i'm looking for something like: netdays between date 1…
Issues with Numbering Children (Child 1, Child 2, etc.)
Hi! I am trying to implement a column formula in Smartsheet that assigns an ordinal number to each of the children in a sheet. For example, the first child would get a "1", the second child a "2", and so on. I've tried several options, and the one I liked the most is the following: Create an auxiliary column with a "1"…
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), "",…

Formulas and Functions

Discussion List

Help Article Resources

Categories

Popular Tags