-
Finding the Percentage from two values
Hi All, Sorry for this very basic question, but I am driving myself nuts trying to find the correct formula. Trying to calculate the total % complete from checked boxes. I have a count for when boxes are checked and a count for the total number of items listed on the sheet. How do I get the % of the checked boxes total?
-
Filter to show only dates from this week???
I'm making a project schedule for our construction company. I would like to be able to have a filter that only shows "Start Date" that is equal to this week or this month. Is that possible?
-
Conditional column formula that updates another column
I am trying to create a condition that if the status column is complete mark % complete column to 100% if in progress mark 50% and if not started 0%. Is there a way to do this?
-
How do I get formulas from a sheet pointing to a template to work when the template is saved as new?
I've got a template built for a repeating project format and I want to be able to roll up key fields from all of the projects into some combined sheets. The formulas work when populating the original project sheet but when I save as a new sheet, the link breaks. This is only a problem in breaking the links going from the…
-
Calculated Column and NETWORKDAY - latency and wrong numbers
Hi, In one of my project, I have a calculated column (Duration) with the formula : =IFERROR(NETWORKDAY([Current Start Date]@row, [Current End Date]@row), 0). When compiling sheets in a report, I saw that the number in the duration column were incorrect. They show the number of calendar days+1. As you can see in the GIF,…
-
Index Match or Max Collect Formula?
I have a form that people can use to submit an "Updated Due Date". This can be Approved or Denied by a supervisor. Once approved it moves to an Approved Sheet with the Move Row automation. Multiple entries can be made for the same project. I have a main sheet that pulls all the data together, and I would like the Updated…
-
How to alert regarding a duplicate value within a row?
Hi I would like to add some sort of alert or conditional formatting, but I'm not sure how to accomplish this. For the columns impacted they are all dropdown single select columns. I want some sort of alert, could be as simple as highlighting the row, if a value in "Faculty on PTO" appears in any other column for that…
-
Summation of costs
Hi all, Disclaimer: SS newbie/teaching myself. I have Control Center provisioning a set of artifacts once a project is approved. Specifically a cost tracking sheet that I'm trying to roll into a Portfolio Summary, and I've hit a wall. I'm trying to roll up all actual costs into the Portfolio Summary in the Actual column.…
-
Auto Add a Date
Hi, I have a Smartsheet with a Check Box for all clients that started services as well a a date column for which date they started. I would like to create a formula where a a date Auto populates, but the date should be 30 days later then the original date of when services where started if the checkbox is checked. As of…
-
Overall Average Percent Compete
Hi All, I have looked around on multiple forms and haven't been able to find a solution for why my formula isn't working.I am trying to determine the formula for the total project % complete of the children rows. For the Project Initiation rows I have the formula =ROUND(IF(COUNTIF(CHILDREN(), 1) / COUNT(CHILDREN()) > 0,…