Formulas and Functions
Stumped by a formula? Ask for help or find examples to see how others use a formula to solve a similar problem.
Discussion List
-
I save a column but it keep returning to previous changeIn Formulas and FunctionsI was trying some changes in my start date column, so i turned my auto numbering to manual date, then I'm trying to turn to auto numbering but it aways changes back to manual date. am I missing something? is it normal?
-
Using Emojis in SmartsheetsIn Formulas and FunctionsWe want to use icons that relate to our work. I have an IF formula that includes emojis. =IF(Classification4 = "BAGS", "🎒", IF(Classification4 = "SOCKS", "🧦", IF(Classification4 = "GLOVES"…
-
Update invoice status using multiple IF statementsIn Formulas and FunctionsHi there! I have the following columns: Actual Invoice Date, Due Date, Invoice Status and, Days Past Due. First, I'd like to have the Invoice Status display SENT if there is a date present the Invoice Date column and then have it display P…
-
Placeholders | Still batching EmailsIn Formulas and FunctionsHi team, I'm using Placeholders in a workflow to generate individual emails for an update request. Although the same individual received the update, they will forward as needed, so I need to ensure each update request for the day doesn't …
-
Use Modified Date to show when the last time a sheet was edited.In Formulas and FunctionsI would like to enter a formula into Sheet Summary that will show the last time a sheet was edited by a specific person. That person is identified on every row in an "Assigned To" column. I have both the Modified and Modified By …
-
How do I get a formula to copy down the colunm automatically?In Formulas and FunctionsHow do I get a formula to copy down the colunm automatically?
-
I cant get the TODAY function to work in this script.In Formulas and Functions=COUNTIFS({Quality Inspection System (Failures) Range 2}, "01-05204", {Date}, >=TODAY(-90), {Date}, <TODAY()) I am new to writing scripts and am kind of stumbling about. I have used the TODAY function once on another sheet …
-
Dashboard Metrix Widget - Modified Date Column For Multiple UpdatesIn Formulas and FunctionsHello, Creating a dashboard with one source sheet and want to show the latest date when any row is modified in the sheet. Easy to select just one cell to represent this with the metric widget. However I need a formula that will pull th…
-
Please help me troubleshoot my SUMIF FormulaIn Formulas and FunctionsHello, I am trying to run a SUMIF formula off of a different Smartsheet using the person in the contact lists formula. I've created the SUMIF Formula below, but it is not totaling the FTE column (Range 4). If someone could please advise, …
-
combine formulas (check flag based on date, OR if checkbox is checked)In Formulas and Functions=IF(Status6 = "Open", IF([Due Date]6 <= TODAY(2), 1, 0), (IF([Send to High Risk Report Now]6 = 1, 1, 0))) I have this formula that each IF function works on its own, but i can't seem to get them to work together. Objective: C…