-
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!
-
List of Unique Values for Dashboard
I'd like to get a list of unique values in a range. I'm finding a lot on the community about how to flag duplicates, but not sure how to get a list where each unique value appears in a cell. Screenshot below is what I'm looking for. My goal is to incorporate that into a dashboard: I want to see all unique values that have…
-
Can IF be combined with INDEX/MATCH AND ISBLANK to provide alternate value for blank results
I can successfully use INDEX/MATCH to look up values between sheets, but many of the results are blank, in which case I need to INDEX/MATCH to a different column of data. Is it possible to use an IF(ISBLANK), perhaps in a nested IF to return the 2nd-choice cell? For example: =IF(INDEX({Directory VP},…
-
IF, Else, Contains Formula
Hello, I have a formula in Excel that looks for key letters at the start of string text and if the condition is met, the cell is populated. The formula needs to be something like: IF [column]@row contains BM as the first two letters then test 1 IF [column]@row contains RH as the first two letters then test 2 IF…
