-
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…
-
Text to Number Issue
So the below formula however its resulting in a text result, i.e. left aligned. I'm then trying to run an AVG/Collect or AverageIF formula on this column however its providing a #DIVIDE BY ZERO result. Any idea/thoughts on how to resolve this? Below is the formula resulting in a 'text' result that I cant run a count/avg…
-
Dynamic View filter
I am revising a column in my source sheet. It has a dropdown window where I am adding more keywords. However, when I go to the dynamic view filters to search, the newly added keywords do not appear. Is there a limit as to how many items will show in a dynamic view filter dropdown menu?