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
Triggers not working properly
I have an automation to send email reminders out at various intervals (30, 60, 90 days prior) based on an Award End Date. But it seems my trigger isn't working properly. Here are the details after a test run.
Referencing an existing field in a formula to perform a calculation based on the referenced field.
I am attempting to build a template where I only need to change one field, based on that field value, in my worksheet that will update multiple formulas in the worksheet. Is it possible to reference a field from within a formula that only using the referenced value in a particular column and row from the worksheet?…
Cross-sheet reference maximum?
Hello! I received an error when I was working on one of my sheets that says: "Unable to create cross-sheet reference, because this sheet already contains the maximum umber of different cross-sheet references." This is the first time I've see it, the sheet it happened on is a dashboard metrics sheet that pulls from several…
Can't get formula to work
All columns are in one sheet Column A - value Column B - status - a selection of drop downs Column C - owners - a selection of drop downs Hi I'm looking to extract the sum of values in Column A (£s) based on matches of data in column B (a selection of 6 out of 8 status) & C - a single select owner I have a worksheet set up…
Formula to convert numbers into a date
Hi, In Excel I can turn a set of numbers into dates by using =TEXT(C3;"mm-dd-yyyy"). i.e. 45513,6038194444 is 08-09-2024 Is there a formula in Smartsheet that can do this?
Formula to change names
Hi there, I am importing an excel doc and there is a column where I need to change the text. Original Name Change to US Ford Passenger Vehicle Concern NA CRC PV Concern US Ford Truck Concern NA CRC Truck Concern US BEV NA CRC BEV Team How do I write a formula that can change the original names to the shorter names? (see…
Total Time Spent On Various Sites
Hi I have a sheet that tracks time spent on multiple sites, I'm trying to add this to a metric sheet but struggling to get the metric sheet to add the total time spent against each site as a total. Can anyone help with the formula for this? Thanks
How to create a basic pricing estimate/quote with dashboard
Hi Everyone How can I create a basic pricing estimate with a dashboard for 4 major service offerings that I am sending to the government for assessment? It only needs to be simple, nothing spectacular. I need something that looks good at the very least with a few metrics involved because its still early days for anything…
Index/Match Formula Across 2+ Sheets
Hi - I ultimately need to index a column from 5 sheets. They are named the same and have the same settings. I could figure out the formula for 2 sheets, but struggling with adding more than that. Here is what i have to capture at least 3 sheets, I'm getting the #INCORRECT ARGUMENT SET error. =IFERROR(INDEX({SC - MASTER…
Workday formula doesn't calculate correctly when value is "0"
Hello All, Having difficulty getting my formula to work properly when a column's value is "0". If the value is >0 it works fine. The formula is supposed to follow the WORKDAY variable and exclude weekends, which it does unless the value in the [Days to add] column is 0 at which point it seems to ignore the workday rule.…
Help Article Resources
Trending in Formulas and Functions
