-
How can I average two count totals on reports?
Hello! I have two reports: Report 1 has the total count of tasks. Report 2 has the total count of sub-tasks. How can I automatically calculate the average number of subtasks per task (number of sub-tasks/number of tasks) from these reports? I know that reports can't pull in ifnormation from other reports, so I'm not quite…
-
Formula to show Current Status of Project Approval
Not sure if this would be accomplished easier with a Formula or with a Update Cell Workflow. We have a Projects Smartsheet that have 4 different Reviewers that need to approve. I'm looking to add another column for Reporting purposes that will show what approval step each project is on. For example, based off my attached…
-
Flag Duplicate
Hi I have a smartsheet that is essentially setup like this: Start Date End Date Start Time End Time Equipment 10/01/2021 10/01/2021 08:00 10:00 Shovel #1 10/01/2021 10/02/2021 07:00 11:00 Shovel #1 How can I flag for duplicate of the equipment? Essentially, if a row is entered and the same Equipment is being used during…
-
Is there a formula or function that allows text to be removed and replaced elsewhere on the Sheet?
Hard to explain just in the question box. We have a staffing schedule for our company which allows us to see who is currently on jobs and who is coming up for availability for an upcoming job. We are trying to figure out if there is a type of formula or function that would allow us to type an employees name in next to the…
-
Percent complete when using date & checkbox field types
I have a task sheet that lists 7 items per row that need to be completed. I would like to calculate the percent complete of these tasks, but am running into trouble with my formula. I have 4 checkbox columns, and 3 date columns. I may not use the check or a date in each, some will have "NA" or text, depending on the…
-
Workday Function Counting Holidays on Another Sheet
Trying to make a function where it counts holidays referenced on another sheet. The formula I am using is =WORKDAY([Test Out Date]@row, 30, {Reference Sheet Column Location}) and I am getting an "Invalid Data Type" error Any idea what I need to do? I dont want to include my holidays on the same sheet cause it messes up…
-
Formula to return a date that always lands on Wednesday
Hi, I'm trying to create a formula that takes a date and returns a date that is the following Wednesday. So it is always a date that starts on a Wednesday. This is the formula I've tried, but it's not working. =IF(WEEKDAY([Task Name]29)<=4,(4-WEEKDAY([Task Name]29))+([Task Name]29),(11-WEEKDAY([Task Name]29))+([Task…
-
Another Nested IF Formula
Could use your help again. Not sure why I have so much trouble with these nested IF statements but I do! When I use the formula below and the Business Unit is equal to EMEA, it returns ASD....any ideas? =IF([Business Unit]@row = "Biologics", "ASD", IF([Business Unit]@row = "Western", "ASD", IF([Business Unit]@row = "Simple…
-
Summary formula Sum of information
Hi All Can anyone please advise on how to quantify two columns in the Summary information? I want to look at the failure column to look for keywords then sum the amount of failed items. Example look for ... OTIF and the sum of issues should report 10
-
Bring the data in a cell over to another sheet based off of other conditions in a row
What would be the best way to bring the data in a cell over to another sheet based off of other conditions in a row? Example: =IF(AND({Sheet A Type} = "Project Status", {Sheet A Status} = ""), {Sheet A % Complete}, "0")