-
How to create a unique number via formula or how to autonumber via formula due to existing autonumber type column?
All, The way my Smartsheet workspace works: Every time the Status column of a particular request in Master sheet is changed, the entire row is automated to be copied to Status Tracking sheet. The change is timestamped as Change Timestamp and the Subsequent Timestamp is recorded in Status Tracking sheet with every…
-
Average days in a status & oldest status date
Hello - I have a client data sheet, and one of the columns is New Account Status. I've added a column called Misc. 1 that tracks when the New Account Status is changed to Ready to Open. I have a separate Metrics sheet to track a variety of metrics on. Making any changes to the main client sheet (changing column names,…
-
Sheet Summary changes overwritten by other users - can this be prevented?
I have a sheet that has sheet summary values I occasionally need to update the formulas for as factors change however I've found that when other users are updating the sheet (it's a testing sheet) the changes I make to sheet summary formulas are overwritten as those users update their test statuses. Aside from making the…
-
Logic Help
I am trying to come up with a formula that will change my "Has been billed" column to Yes or No based on the dropdown choices in one column and the created date, I am having trouble coming up with some logic that can work around the year with sporatic billing periods. Here is my current formula: I either have remnants from…
-
Created Time
So I am trying to extract the timestamp from the created date column and its making me feel crazy. The TIME() function help file describes a formula that should work exactly how I want - however NOTHING as described works at all. (https://help.smartsheet.com/function/time) =TIME([Date Created]@row) returns "INVALID DATA…
-
Annual/Recurring Tasks
Hi all! I am trying to create a recurring due date for annual tasks. Currently, I have columns for Due Date, Next Due Date, Status, and Annual? checkbox. Ideally, when the Due Date is in the past and the Status is "Completed", I would like the row to essentially reset to "Not Started" and a Due Date of the same date + one…
-
Newbie Question - Need new sheet column to reflect what is on another sheet
Hi all! I'm new to Smartsheets and am struggling through learning how forumulas work still :-) I need column A in "Sheet 2" to reflect the value of column A on "Sheet 1" in the same row. So for example if row 1 on "Sheet 1" is 'Apple' then I want column A on "Sheet 2" row 1 to also say 'Apple'. I've done some searching and…
-
Linking Columns Across Multiple Forms
Hi! I want to link two columns (Pre-Assessment and Post-Assessment) from my Learner Management Tracking List to my Leaner Data Jan - Dec 2026 sheet. I know who to do the formula. My concern is that the Learner Management Tracking List is live data and we create a new data sheet every year. In 2027, would we just edit…
-
Formula to Indicate Current Month in 90-Day Grace Period for 26 Certifications
I have a sheet that list people on a team in rows with columns containing 26 certification types. Each certification type has a certification date that is also the start date of a 90-day grace period. I have included an end date field for the grace period and a checkbox field to indicate if the person in the grace period…
-
NETWORKDAYS
I'm dying over here! I have tried this formula countless times and #unparesable keeps populating. I am trying to calculate thew amount of days between 2 dates. My column name is Date and Date Complete. I created another Column titled Days to Complete. This is my formula. NETWORKDAYS([Date], [Date Complete], [holidays])…