-
Linking a cell (date) to another sheet and adding extra days to in Smartsheet
Hello Community, I need to link a cell to another cell (different sheet) and also add extra number of days to the value in the cell. What is the best way to go about this. The cells are dates, for example Sheet 1 has cell A = 12/05/23 needs this cell needs to be imported to Sheet 2 cell B plus 10 days.
-
Task Health - Red, Yellow, Green
I am currently using =IF(TODAY() - [Due Date]@row < 0, "Green", IF(TODAY() > [Due Date]@row, "Red", IF(TODAY() - [Due Date]@row < [Processing Goal]@row, "Yellow"))) because I can't figure out how to get the yellow to work correctly. I am looking for a formula that will display green if today is less than the due date, red…
-
Past Due date
I am trying to figure out a way to high light the row, when the date requested has passed it 7-day return. Even if date receive is blank, I want it to highlight the row because the current has been more then 7 days. Currently on the duration we have it counting once we enter the date receive. I don't have it highlight when…
-
RYG status set by % Complete and End Date
I am using a Smartsheet template (Project Tracking Template) and it comes with RYGB statuses. I would like to only use RYG and adjust the formula but am failing miserably. Please help!!! Here's what I'm trying to accomplish: Green = If % complete is 100% or if end date is greater than today Yellow = If % complete is not…
-
Date & Time
Hello- How do I add the date and time from start of task to end of task from this form? I need to measure the date and time from start to finish. I'm using the FORM. Thanks.
-
Find top Ten numbers from a large list in a column
I want to identify the top ten users from a dual-column list, where the first column signifies the item and the second denotes the corresponding numerical value. The objective is to pinpoint the top performers, contingent upon the values in the second column. Additionally, I aspire to generate a graphical representation…
-
Can health status be dependent on another cell's value?
I would like to make a column of health dependent on the status column. Not started -> grey, at risk -> red, etc. I typed the following formula but am not able to generate results. Is this a possibility in SS? If so, what am I doing wrong? I'd like to apply the formula to a whole column, but SS is kicking back a syntax…
-
Date Comparison Formula Help
I am a SmartSheet novice, but my team is used to base tracking in SmartSheet. I would like to set up conditional formatting that highlights if a site's planned schedule puts the site at risk. I would like to compare two columns: "Construction Schedule: Turnover to Retail Date" against "Exterior Installation: Scheduled…
-
How do I fix this error #INCORRECT ARGUMENT SET
Working Formula: =IF(ISBLANK([Site Occupancy Meeting Date]@row), "01_SOR Needed", IF(ISBLANK([Right of Entry Received Date]@row), "02_ROE Needed", IF(ISBLANK([Matterport Inspection Date]@row), "03_Matterport Needed", IF(ISBLANK([Notice of Eligibility Sent Date]@row), "04_NOE Needed", IF(ISBLANK([Comps Completed Date]@row),…
-
What is wrong with my formula?
Hi all, I'm trying to write a formula with the following conditions to get the % Complete Complete - 100% N/A- 100% Outstanding - 0% Partially Complete - 50% for example, if we have 4 tasks - 2 of them are N/A and 2 of them are complete - it should be 100% since N/A and complete acts as 100% if we have 2 partially complete…
