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.
Discussion List
Date/Time Stamp Option
While trying to figure something else out, I stumbled across a new option for having specific actions date/time stamped using the stem generated Modified (date) type column and the new Copy Row automation. . DISCLAIMER: This does not scale very well as is. If you have a lot of rows you are wanting to track a lot of changes…
min(collect()) but not the first one
Hello, Code below checks first in line when there multiple identical fields in LevNaam Created2 = autonumbering (incrementing numbers but not following up on eachother so i cant use +1) =IF([Created2]@row = MIN(COLLECT([Created2]:[Created2]; Levnaam:Levnaam; Levnaam@row)); 1;0) shows created2 "1" as checked is there a way…
AUTOMATE PROGRESS BAR BASED ON MULTIPLE CONDITIONS
Hello, I am trying to automate my progress bar, basing it's progress on multiple conditions. I have 10 columns I would like the progress bar to consider. Example below of how i would like it to work: If Cost 1 AND Hours 1 IS NOT Empty then progress = 25% If Parts AND Survey AND time IS NOT Empty then progress = 50% If…
Maximum cross-sheet references
Once you reach this figure of maximum cross sheet references how can you get around this. I want to configure calculations to 2030. Got to June 2025 before I got stuck. Regards Steve
Last Modified By
I'd like to find a way to display the Last Modified User and Last Modified Date for a specific cell reference. This data is captured because it shows up in the activity logs, but how would I show it? Not for the entire row...but for a specific cell in that row? The use-case here is a question / answer sheet where we can…
Rolling Fiscal/Quarterly Counts?
How would I go about populating the number of something happening within a certain Quarter or Fiscal Year? In this instance, I want to count the number of Cross-Dock orders that happened in the last quarter, but then also for the entire fiscal year. Another example of how I'm trying to use this is that I'm trying to gather…
Query String - How to send text with spaces ?
Dear Community, I am quiet new to Smartsheet and would really appreciate your help. I am trying to insert query string into formula and face an issue: Only text before first space symbol is actually sent to the form. Please, see a screenshot below: So, when I open a form via this link in Title field I see only TestIdea2…
Sub-Report
I am looking for a way to create a sub-report within Smartsheet reports. I currently have a report that shows all the information about jobs I have going to the manufacturing floor. The "M" number under the Primary column is the job number. This is fed from a sheet that hold all the relevant information. I have a second…
How can I link a milestone from one sheet to another sheet?
We have identified a key milestone (e.g. row 38) that we'd like all our other workstream sheets to link to. Reason being whenever that key milestone moves their plans will get automatically updated. Is this possible using a specific formula or function?
Formula Help
I have a Sales Commission column and an Invoice Total column. I need the Sales commission column to show 5% of the invoice total column. Any help with the correct formula. Thanks.
Help Article Resources
Trending in Formulas and Functions
