-
Formula for automating Health status of project
I have two formula questions. 1. I have Parent rows with a rollup formula created that takes the avg of the RYG balls of its childreen and creates a status =IF(COUNTIF(CHILDREN(), "Red") > 0, "Red", IF(COUNTIF(CHILDREN(), "Yellow") > 0, "Yellow", IF(COUNTIF(CHILDREN(), "Green") > 0, "Green", "Gray"))) .... I also have aโฆ
-
Calculating Weekend Days Between Dates
Hi, Looking for a way to calculate the number of weekend days between two dates. Many calculations use the total number of days and divide by 7, but this only gives you total weeks. For example, if a task starts on a Thursday and ends Monday the output should be 2. If you divide this duration by 7 it will give you nothing.โฆ
-
TODAY() Function is Replacing Previous Date
Hello, I have a column in a production spreadsheet that I am utilizing to enter the date of which one of our production members completes an order. The columns are set up as follows - one column is an initials column where a production member selects their initials once they complete an order. The second columnย containsโฆ
-
Help needed with formulas - paid work opportunity!
Hi everyone, My colleague and I are new to SmartSheet and we are having some issues with a few formulas and we can't quite work out what has happened. We are offering paid work at an hourly rate for someone to join our team to help troubleshoot and fix our SmartSheets issues. If you're interested, please let me know!โฆ
-
Daily Average formula counting too many days...
Hello, I recently had pro desk help set up the following formula and it is counting more days then it should. I would love your help in solving this issue. Thanks Intended formula function: My smartsheetย has date entries with totals. In my other sheet that is gathering the grand totals from this sheet, I wanted to come upโฆ
-
CountIF with wild card
I'm trying to count the number of items in a column where part of the text shows. Is there a way to do this? For e.g., I'd like it to count up the number of rows from a column in which the words "ids" show up. Keeping in mind this only part of the text (e.g. some rows say "ids?", "ids due", "IDS? Client refs" etc." I'veโฆ
-
RYG Ball Automation
Hi there, I am trying to automate the 'Health' column on a sheet. I have it set up to turn RYG when a certain status is selected but I would also like it to turn Red if the Due Date or Due for Review is a past date and the status is still listed as anything but 'Complete." I currently have this formula in placeโฆ
-
Need help with formula to calculate end date with % complete.
Hello, I need assistance with creating a formula to look at the end date and % complete columns. If the end date is nearing and the % complete is less than 100% the corresponding RYG should appear. The durations of each task varies from 1 day to 100 days depending on the project phase. What formula do you recommend for theโฆ
-
Counting using Countifs if a date is present
I'm trying to create a countifs formula where if it finds a date in a column and is a particular county, it'll count that line. I tried this and don't get an error, but it returns a zero which is not correct. Thank you!! =COUNTIFS({McAdvCareSiteReview Range 2}, (ISDATE(true)), {McAdvCareSiteReview Range 1}, "king")
-
COUNTIFS problems
I am doing a metrics sheet to give department heads better visibility on our workflow. One of the metrics I need is how many items have been shipped, but not yet invoiced, I have a date shipped culumn (date) and an invoiced check boxย (boolean). Several other formulas have similar setup criteria and are also not working.โฆ