-
Formula for "Overdue" in Status Column
I'm having trouble with creating a formula that flags my status column as "overdue" when I'm not at 100% complete and past a tasks end date for that line. i've read a lot of the other posts but none of the formulas seem to apply or work when I input them. Please let me know your thoughts. Thank you!
-
Formula for RYGG symbol based on RYGG symbols in 6 other columns
balls. The 6 other subcategories/column names are: * Financial Status * Quality Status * Staffing Status * Delivery/Operations Status * Customer Satisfaction Status * Subcontractor Management Status The Overall Status is green if all subcategories are green. The Overall Status is yellow if 1-3 subcategories are yellow. The…
-
put current date when checkboxes are checked
Hello, I want to configure a formula to set the current date when 2 checkboxes are checked. I have configured 1 date column and 2 checkboxes columns. I don't want to use the auto-modify date column for this purpose. Please help.
-
Auto assign based on value in Field
I would like to auto assign and update the Assigned To field based on a value in another field. I've tried something like this; IF([Contract Type]=NDA, John Doe) So if Contract Type equals NDA, then put John Doe in the Assigned To field otherwise keep blank. Can someone assist?
-
Ignore Parent Records formula & Ranked graph
Hello. I am trying to create a graph that shows the top 10 tasks ranked by the variance between Initial Duration and Actual Duration. To make this work, I want to ignore tasks that are parent records. What would this formula look like? I have created a formula to rank the Variance; =RANKEQ(Variance1, Variance:Variance, 1).…
-
Dates in formula AVERAGEIF
Hello, I have problem with the dates in the formula below (in sheet summary) =AVERAGEIF([Date of request]:[Date of request], >07.01.2019, [Completed in days]:[Completed in days]) The Smartsheet returns me the value 0 that is wrong cause I have lots of numbers that meet this criterion. Please advise and thanks in advance
-
Finding the free project dates
Hi I am running a number of tasks in a sheet, with each task having its own Start and Finish date. What I need to find out, is a "free" period when there is absolutely no task running. Example: Task A is from Jan 1 to 10; Task B is from Jan 5 to 12; Task C is from Jan 16 to 20; Task D is from Jan 15 to 25; and so on.... In…
-
Creating a PMO functionality
I have just been assigned the task of setting up the Project Management Office in my company. For now I need two things, firstly a project tracker for tracking and monitoring individual projects and then a master portfolio tracker where all the info that's updated in the individual trackers feed into. This master tracker…
-
Hot Tip: INDEX/MATCH Formula "Shortcut"
Copy/paste this to quickly build these formulas: =IFERROR(INDEX(ReferenceSheetPickContentColumn, MATCH([CurrentSheetMatchColumn]@row, ReferenceSheetPickMatchColumn, 0)), "") Then just double-click the concatenated-word segments, replace the outer ones using the ReferenceAnotherSheet link from the Formula Help panel that…
-
Set default text for a given cell
I am creating a template and would like certain cells to give an example or show what type of information should be entered. The default text should be in that cell always unless other text is entered in. If the newly entered text is deleted, the default text would show up again. In doing some research, this type of field…