-
Days left on a Term End Date
Hi all, I was wondering if there is a function that conveys how many days are left for renewal license as seen in the image. Obviously the dates listed have been expired & I was wondering if a negative positive function can be conveyed as an example -1,847 in the "Days Left Till Expiration" column
-
Does Smartsheets have a CASE Statement function?
Does Smartsheets have CASE statements? Or am i forced to use nested IF's?
-
Checkbox formula using =IF(OR
Hi, I am trying to find a formula to check a box based on another cell in the row having either maintenance OR support (along with other text) but keep getting an #INCORRECT ARGUMENT SET error. The formula works perfectly for one criteria i.e. =IF(FIND("Maintenance", $[Item description]@row) >= 1, 1, 0) but when I try to…
-
Countifs where sheet range is formula returning a number and criterion is sheet summary dynamic drop
I have a column called '"Wave" which shows a number 1-10. The value is returned on some rows from a =PARENT formula and on some rows it's hardcoded. (I understand it should be either formula or hardcoded but go with me here...) I have a sheet summary which works perfectly well when the 'Wave' column in my sheet is…
-
Is there a way to trigger a flag in the header row when there is 1 or more flags in the column?
I am trying to see if there is a way to have the flag in the title row go off when any flags are triggered in the sub rows below. In the photo attached, I would be referring to the blue row that would flag since the other white rows below it have 1 or more flags. I am not sure if this is possible, but figured this was the…
-
SUMIFS giving #INCORRECT ARGUMENT SET
I need to sum up the total wall volumes processed on a given day at a given time. I am using a SUMIFS statement to sum the wall volume when the date matches a specific one, and when the time of day is 3:00 PM This is the formula I have: =SUMIFS([Total Walls]@row:[Total Walls]@row, Date:Date, =[Every Date]@row, [Time of…
-
Repeated Task
Hello all you wonderful SmartSheet users I am trying to find a way to represent a repeated task and the associated information (Start /finish Dates, Status, % complete) from the first time this task is completed. i.e. I have a drawing and its associated sub tasks. This drawing is a sub-task in a later drawing. As such, I…
-
Need assistance with formula
I have this formula on a column =IF(Status@row = "Complete", "100%", ="In Progress", " %"), I want the user to be able to add in a number when the status@row is "in Progress". How can I write the formula to be able to allow the user to type in a progress level. "In progress" may be 75% or 50%
-
Help with Join Collect formula
I have a long list of subcompetencies, that are mapped to course objectives across courses. What I would like like a formula that displays subcompetencies where objectives are equal to "NA", but if the subcompetency is already mapped in a different course to a course objective, then do not display. In other words, i need a…
-
sumif with multiple conditions and will need to divide total
Hi In need of some help. I would like for the formula to sum and then divide a total if two conditions are met condition 1: must be a yes using the green dot with a check mark symbol Condition 2: must be equal to CV PIP AC Then the formula should total up and divide by 5 the values in "Total Contract Hours" column that…
