-
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…
-
Auto Generated Unique ID
Hello Smart Heads! Happy New Year! I am facing an issue with big data sets, missing a single unique ID. The only option of creating an unique ID is by joining content from 3 various cells, see: id is created by using simple formula: =EntryNumber@row + BLNumber@row + ContainerNo@row In a raw file (excel of course), I have…
-
How many formulas can a sheet summary hold?
I have a sheet with a hundred some formulas and I will probaby have 200+ at the end of it. Will I have any issues with that?
-
Dates - Nth date formula
Good afternoon, I have searched the smartsheets community far and wide for this answer to no avail. Would anyone be able to assist me in creating formulas for two different scenarios: 1.) I need dates for every Friday for the remainder of the year 2.) I need dates for every second Thursday and Friday for the reminder of…
-
Concatenating Dropdown Responses with Exclusions in Final Column
Hi all, I've been deliberating on this one for a while now and not getting anywhere. I have 20 columns which are single select dropdown (with the possibility to free type also). As an example, one of the column's choices are: Compliant Missing ToB ToB not initialled Incorrect ToB template used Incorrect ToB uploaded N/A…
-
Finding the most recent entry
I am having issues finding the most recent update to my list of fleets. I have read about the Max(Collect()) function and don't quite get the result back that is needed. I get incorrect column value, incorrect funciton, etc. or when I have been able to get it to run I get back a 0 instead of an actual date. I have tried…