-
Calculating SLA based on time/hour formula
Hi @Paul Newcome I thought I would write a new thread and @ your name on this post. Hope thats ok. Taking this from Formulas for Calculating Time thread. --------------------------------------------------------------------------------------------------- @Paul Newcome What a thread! Came across this when I was looking for a…
-
Flag should turn red whenever over due day is over 30 days and status is not completed
Hi everyone, I have a 'risk' column with flag, it is supposed to turn red whenever status does not indicate 'completed' and 'due day' is already beyond 30days, except if the status was cancelled. I used the formula below but all the flags turned red automatically, I do not know what I am doing wrong, please help: What is…
-
Auto update % Complete while whenever status is updated
Hi Everyone, I have status column with drop down list of Not started, Cancelled, In progress and Completed. I would love the percentage complete column to auto populate anytime update is been made on status column. I would love to have Not started and Cancelled as 0%, In progress as 50%, Completed as 100%. Hope anyone…
-
Next Item Due
Hello, I would like to create a widget in a dashboard that shows the next task that is due in a list of upcoming tasks due. If I have a column that says the task with a corresponding due date column, how would I be able to display the nearest upcoming task due? Thanks.
-
Time calculation formulate when time goes into another day
We have this formula that is working well to calculate total hours worked. The issue is when the time rolls into the next day. I can get a formula to work great in excel however having troubles here since smartsheet does stuff a bit differently. We do not ask for start date vs end date so only working with time. Does…
-
Check for Duplicates and Blanks
I want to check a column for duplicate entries, but if the field is blank, I want it to be ignored. So far, here's what I have. It works for checking duplicates, but if it's blank it still sets it's value to 1 (because there are multiple blank rows). I'm using this for an automation script in a column formula to have all…
-
Automation triggered by INDEX / MATCH cell value changes
Howdy - I feel like I've tested this every which way but didn't want to throw in the towel until I asked the community. Is there any way to run an automation (specifically "Copy rows to another sheet") based off a changed value via column formula INDEX / MATCH? My goal here is two fold: limit the number of columns added…
-
Sumifs Formula with a Contain
I am trying to get the sum of hours worked IF the "Office" Column = Administrative Solutions. The Office column is a multi-select dropdown. =SUMIFS({Project Intake with Form Range 1}, {Project Management Tracker- Discovery to C Range 9}, CONTAINS("Administrative Solutions", @cell")) Any help would be appreciated! Thank you!
-
AVG(COLLECT) Formula Questions
I've looked at a lot of posts already about using this formula and have tried all the suggestions but I'm still getting an UNPARSEABLE error. Hopefully, I'm just doing something simple wrong, like having a common in the wrong spot. But I want to use two criteria... if the MRD column is checked, and the Task Name equals…
-
Assignee counts get skewed if multiple assignees
If my Assignee columns has multiple people in it and data in the row gets skipped in this count. this is the old formula: =COUNTIFS({Assignee}, Team3, {Status}, "In Queue") Anyone out there have any suggestions.. I have been trying this: =COUNTIFS({Assignee}, CONTAINS("John Doe"@cell), {Status}, "In Queue")) Even if the…
