-
Using IF(AND to mark yes if 3 different columns are true (one ISBLANK and one (NOT(ISBLANK))
Hoping that someone can help me figure out what I am doing wrong in this formula or another way to do this. I want the "D84 OOW w/No complete date" to say "YES" if the "D84 Completed date" is BLANK, AND the "D56 completed date" is NOT BLANK, AND the "D84 window end" is < today [note: D84 window end will be populated when…
-
Tracking that project has an update or not
I have a project tracker for my entire team with very simple information as it is a very high level overview of all active projects. My CEO will be checking the information weekly so I planned to do a Weekly Update Request that goes out to my team to 'remind' them to add any updates to their projects. Since some of these…
-
How can I chart the last 7 days that contain data?
Hello, I am capturing audit data utilizing the web form for smartsheet, and would like to use a line chart to show average compliance per day, for the last 7 working days. With the holiday weekend that just occurred, I have a 3 day hole in my chart. I have been brainstorming and am trying to come up with a formula that…
-
Using COUNTIF and CONTAINS to count the number of times a word is found in a children rows.
Hi I am trying to find a way to count the number of child rows that contain the word "Updated" and have a combined total of the number of rows that contain "Updated" in each of the levels of ancestor rows. Thus far my formula is: =COUNTIF(DESCENDANTS([Packaging Job]@row), CONTAINS("Updated", DESCENDANTS([Packaging…
-
#NOMATCH returned on Sum(children())
Hi all, I'm a bit puzzled. I'm using this formula where H1 is a column that identifies titles (0 being a child, 1 up to 5 being the hierarchical level) to sum the cases that are reported from the second part of the formula (If (Site Management OR Alkalin), AND (not completed and due date within 30 days....) put 1 And the…
-
IF (AND formulas
Hello - I'm trying to indicate which tasks are at risk by raising a flag when the due date is past due and the task is not 100%. This has worked in other smartsheets for me, but when I copy the formula into a new smartsheet it is not working. I'm using: =IF(AND([Finish Date]@row < TODAY(), [% Complete]@row < 1), 1, 0) Any…
-
Change number of hours per day before it proceeds to the next
Hi all, I'm currently running a project that my resource only work 3 hours a day on. Can anybody advise if it is possible to setup something that dictates number of working hours per day before the date goes to the next day? eg. If i assign a resource 6 hours of work on a Project A (considering the resource only work 3…
-
Count a drop down selection in entire column
Hello please see attached photo. I am wondering how I can count lets say "90% CD" for the entire column. Each of the choices come from a drop down menu. So essentially I would like to be able to count how many "90% CD" and "70% CD" etc. Thank you!
-
How do I cusomize system generated date created?
This generates a date and a time. How do I customize so I just get the date. I can then use a formula to count across a date range. I cant if thee is a time in the cell too.
-
Is there a way to have a cumulative formula?
Hey everyone, I would like to know if there's a formula that calculates the cumulative time because I have to drag it down everytime. I have 3 columns: 1) Task 2) Task Duration 3)Cumulative time I know that for row 2, I can just do [Task Duration]@row + [Task Duration]1, but I can't do that for row 1. Also, by using this…
