-
Getting Status of Children to roll up to Parent Row
I have Parent tasks with Children tasks in a dropdown list column. The options for the children are: assigned, in progress, complete. would like to have the parent status display be blank if none of the children have a status selected (all are blank), display "Complete" only if all the children have a complete status,…
-
Report Builder
I have searched but can't find an answer. I am building a report and want to set 'what' as the following: "is a number does not contain - total" However the 'exclude selected items' checkbox only seems to operate for all conditions and I therefore cannot get the desired combination (I can have is not a number and does not…
-
Summing hours worked based on date criteria
I have reviewed the threads related to this but am currently getting an invalid value error when attempting to sum a column based on a date range. Here is what I have =SUMIFS({Ford Chicago Accounting Range 1}, {Ford Chicago Accounting Range 2}, @cell < DATE(2019, 16, 8)) Where Range 1 is the hours, Range 2 is the dates,…
-
Duration Vs Project Days
I have a project where the planned tasks are spread over several weeks, see attached. How is the summary % complete total calculated? Can I relate to %complete against project days? Regards Steve
-
If Statement Formula Unparseable
Anybody able to explain why the following formula is coming up as #UNPARSEABLE =IF(AND(ISBLANK([Contractor CO Submittal Date]@row), ISDATE([Company CO Response Date]@row), [Company Response]@row = "New CO to Contractor"), "Contractor Response Needed", IF(AND(ISDATE([Contractor CO Submittal Date]@row), [Contractor CO…
-
Project Time in Minutes vs Days
Has anyone tracked a project by minutes vs days? Goal of the SmartSheet project is to create a software upgrade by minutes vs days. Issue: The software upgrade typically takes 2 to 3 days. The upgrade schedule is by minutes and resources and task need to be schedule by minutes to plan the time the system will be down.
-
Forms
Hi, I understand how to create forms but I don't know how to view the data within the form. I assume this is the easy bit but I just can't find it. Any help much appreciated
-
Enhancement Request -> Transfer license & Sheets at same time
I just encountered a situation where I wanted to transfer a license and sheets at the same time, and was unable to do so without a workaround. I had to either get the person to transfer all their sheets to me, then change the license, and switch them back to the new owner, or take a license away from another user, give it…
-
Dashboard on a Rollup Sheet
We have multiple projects in a sheet and created a rollup sheet to track all of these sheets. How do we create a dashboard on top of that sheet?
-
Resent Request for Approval
Is there a way to send a reminder to someone who received an automated request for approval? I have program chairs who are either not responding or are not responding in a timely manner, so the Approval Status remains "Requested". Right now, I reset the status so it triggers the automated request for approval again. It…
