-
Support - Formula that calculates difference between times in a quarterly increments
Hi Smartsheet Community, I'm attempting to figure out a simple formula that would calculate the difference between 0800 and 0830 in quarterly increments. At this current time i'm unable to figure out how to create a successful formula that would show the correct -0.50 for the following. Should 0825 and 0900 be entered, the…
-
Use IF THEN Formula
IDK what I'm doing wrong as it Allllmost works. Trying to create a formula to say, If you look at this overall score... if it's 0 - 54 = Tier 3 If it's 55 - 90 = Tier 2 If it's 91 and beyond = Tier 3 I'm using this formula... it works except it won't display tier 3... =IF(Answer21 < 55, "Tier 3", IF(Answer21 > 54, "Tier…
-
Index Match question
Hello, I have 2 sheets, 1 is a tracking sheet, the other is a reference sheet. I need to pull into the tracking sheet a dollar amount from the reference sheet. The dollar amount is based on the information pulled from 2 different columns - Job Title and # of hours. I tried to use a join function to simplify the index…
-
How can I log a timestamp of a cell change?
I want to add an automation rule to write a timestamp of when a cell value changes, I know I can use the "record a date" automation to get the date but is there any way I can get the exact timestamp similar to the "created at" field in form responses? I am also looking into a way to implement it using the API and there…
-
Dashboard with Set Time Frame Options
NOTE: I am a Smartsheet novice. I need to set a formula I can use for setting up a dashboard that counts specifics within set date ranges and enables users to see data sets within specific time frames. For example, 14 days ahead, 30 days behind. Can please someone assist?
-
Can you Change the End Date when Status Changes?
Is there a way to change the End Date to today, when a status is changed to either Completed or RYG is Green?
-
Multiple IFs around Dates
I am trying to create a column formula that says if [Date of Record]@row is less than a specific date (7/14/23) for instance, then return the number 43. If it is between 7/14/23 and 8/22/23 then 46, and so on. Is this possible?
-
Highlight duplicate entries
Hello, We are using Smartsheet to track payables and would like some sort of conditional formatting or formula to alert us if an invoice number is a duplicate on the same sheet. Is there a way to do this? Similarly, could we use a formula to look to other sheets as well? Or are formulas self contained within each sheet?…
-
Did I make it too difficult to calculate?
Hi, I am a rookie when it comes to formulas - and while I understand the basics, I feel stuck with one thing related to a sheet that will start coming data collection soon, and I want to ensure the formulas are all set before it starts. Here is where I am stumped: I have a column on my smartsheet where one option let's…
-
Formula to show date in Fiscal Year
I located the formula to create a Fiscal Year from a date (January to December) ="Q" + ROUNDUP((MONTH(Date@row) / 4)) + " " + YEAR(Date@row) 1/7/2021 = Q1 2021 But our company Fiscal Year is November 1 to October 31. I cannot figure out how to edit this formula to work. Thanks!
