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
-
How to pull the next due date from a list of up coming dates from a different sheetIn Formulas and FunctionsI am fairly new to Smartsheet and still getting a feel for the landscape. I have two sheets, one is my main sheet where I want the dates to be pulled into, the second sheet is where I have my upcoming due dates. Essentially what I am try…
-
Formula HelpIn Formulas and FunctionsHI, I need a formula for the screenshot below that looks at if 2022 Show Start Date is less than 90 days out and Rebook Plan in Place column is unchecked, assign the status column as "Red" and if checked then the status is "…
-
Countif the Month/Year matches the current Month/Year?In Formulas and FunctionsCurrent formula displayed at bottom. It counts the amount of Values in Range 1 that are created in the last 30 days. The formula works, however I'd like to change the second countifs statement, in particular the Today(-30) so that it match…
-
Did the COUNT formula change to include blank?In Formulas and FunctionsI want the COUNT formula to only count checked boxes. Yesterday, this was the way the formula worked today, it counts checked and unchecked boxes. Does anyone have any idea why this changed?
-
Display a city name based on a textIn Formulas and FunctionsHello everyone, I want to display a city name based on a text, for example: COLUMN A T1 = Toulouse T2 = Bordeaux T3 = Paris T4 = ... A cell in column A can contain a single character (T1) or several (T1 + T3). In column B I would li…
-
How to flag a row if a checkbox is unchecked for more than 2 weeks in a rowIn Formulas and FunctionsMy team uses a hierarchical sheet to track weekly student attendance by checking the 'Check In Data' box if a student is present. I want to create a column or formula that will flag a row if the 'Check in Data' box is unchecked for TWO WEE…
-
Countifs helpIn Formulas and FunctionsI have a sheet that has a column for the date and the second column that states "yes" or "no" beside the date as to if we have had an accident. This second column is called safety. I am trying to write a formula to co…
-
Duration Counter/TimerIn Formulas and FunctionsIs there a way in SS, that when using an auto-generated created date/time, that a duration column will count how long since it was submitted. Then have a date & a time column for completion that will stop the timer?
-
Can Smartsheet forecast end date base on % complete inputIn Formulas and FunctionsFor example: Start Date: 10 Jan 2022 (Mon) End Date: 14 Jan 2022 (Fri) For simple calculation, working day duration is 5 days. Each day should achieve 20%. Today is 12 Jan 2022 and I should achieved 60%, but I only manage to complete 40%.…
-
Excel to Smartsheet formula conversion errorIn Formulas and FunctionsHello All, I am trying to import Scaled Agile Team Event calendar excel onto Smartsheet. I am facing difficulty in automating Column F - Team Events on Smartsheet. If someone can help me debug the query to work in Smartsheet. I am atta…
