-
Formula to pull constant number string from variable text strings
I have a Notes column that often includes between one and five 9-digit number strings somewhere within the text. In Excel, I used the formula below to pull the numbers from the text into one or more subsequent columns. =LET(arr,TEXTSPLIT(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(N84,"'"," "),";"," "),","," "),"…
-
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…
