-
Add days to a date. Formula help
This discussion was created from comments split from: Can't add days to a Date.
-
"Hello SmartSheet Community. I am trying to capture weekly data amounts based on specific date range
"Hello SmartSheet Community. I am trying to capture weekly data amounts based on specific date range referencing another sheet. I thought this formula would work but keep getting back an error. =COUNTIFS({ACF Conferencing Request Assigned Host and Tech}, CONTAINS("Alexander Tsehay", @cell), {ACF Conferencing Request Date},…
-
How do I get Working Days remaining to stop counting once a task is complete?
I'm using a SS template that has start/end date, working days remaining, duration, % complete and status. If I mark a task 100%, it automatically changes my status to "Complete". It's a nice little automation. What I'm noticing though is that the working days remaining field continues to count and I have a "-" (negative)…
-
Having multiple time zones on one sheet
Hi there, I work with team members across 3 time zones (CET, IST & EST) so would like to display start and end dates & times for all 3 time zones. Currently my sheet is set up as follows: Start Date: normal date column Start date time CET: formula: =[Start Date]@row + "" — I have predecessors enabled and after extensive…
-
Flagging Duplicates with Multiple Criteria
Hi all, Trying to identify when I get a duplicate that meets both criteria, when the Work Order Number is the same and when the Service Area is the same. I'm using the following formula, =IF(COUNTIFS([Pass Number]:[Pass Number],[Pass Number]@row,Site:Site,Site@row)>1,"Duplicate","Not Duplicate") But its not working…
-
Hello! How can I work an OR statement into this formula? I need it to look at 6 different columns.
=IFERROR(INDEX(COLLECT({Provider being reviewed}, {MRN 1}, CONTAINS(@cell, MRN@row)), 1), "")
-
Using the Copy Rows Function Within A project Template of Sheets
I am having an issue when I am trying to move a row of data to another sheet within the folder structure of a Workspace. When saving the workspace as a new workspace (for a new project for example), the sheet containing the automation to copy the row to another sheet continues to point to the original sheet, and not the…
-
Link % completion and Status fields
We have 2 columns. 1) % completion 2) Status (not started, in progress, completed, significant delay, etc). We would like that every time we move % Completion from 0 to any number up to 100, Status gets automatically updated to "in progress". And when % completion hits 100%, then Status is "Completed" We will still want to…
-
Creating Dynamic View with Single Value Display in a Multi-Value Column
I have a column that can hold multiple values, but I'm looking to create a dynamic view where only a single value is displayed. While I'm aware that filters can accomplish this, I want the view to exclusively show that specific value. Does anyone have a suggested solution or workaround for this?
-
Percentages as progress bars
Hi we are using the below formula to calculate a percentage which is then reflected by a progress bar, when the overall percentage is at 49% the progress bar is showing as "full" instead of reflecting the criteria of the formula underneath =IF([Overall %]@row < 0.25, "Empty", IF(AND([Overall %]@row >= 0.25, [Overall %]@row…