-
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…
-
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,…
-
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…
-
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…
-
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…
-
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])…
-
Simplifying Index / Match function
Hi Community! My goal is to have a formula that indexes the "Status" column in my 2.0 WMTN sheet; i have built this formula however the below is only referencing 1 of 5 sheets, so i will need to recreate all the IF functions 5 times over…this isn't very efficient and there's a chance a new task can be added, which then…