-
% Complete formula
Hi, I need to be able to calculate the % complete of a project in the parent row based on % complete of a number of tasks in the child rows and the project duration without using Predecessors column. Can anyone help?? Thanks, Bill
-
countif red text lines
Hi, want to count "at risk" check boxes to present at a dashboard. so I thought fx=COUNTIF(Status2:Status14, "red") works, but it only produces 0 as result Any suggestion Thanks
-
Gantt - Task Name, Start and End Date
Hi...I would like my gantt chart to show the task name, start date and end date. Is this possible?
-
Ticketing Sheet: Update Request to Group?
I'm using the ticket template and want to use the update request feature. Currently it seems like the only way to do an update request is to assign it to a specific user, which doesn't make sense if you have an entire department working on tickets at different times of day. How do you request an update to a ticket (row)…
-
Gantt Report for Several Sheets - Can I drag & drop dates in the report?
I would like to be able to drag & drop Gantt dates in my report as we have several projects going concurrently, and the report is great for big picture. How do I do that? Also, how do I reflect a pause in a project, as in we're waiting for info from a client but are working on other jobs in the mean while? I would like it…
-
Nested IF Statments
I'm trying to add the below "IF Statement" but I get the "#UNPARSEABLE" error. "Weight22" is cell that contains the "70%" (which is calculated from a formula. I want the IF Statement to return the "Below Average" / "Average"/ "Very Good"/ "Excellent" based on the % cell next to it. I'm new to smart sheets so I don't really…
-
Sumif Help please
I want my totaling cell to add quote on the criteria below. I have a drop down list in column 1 , in that list I have (con/fine, con/course, con/xtra, ash/fine, ash/course, ash/xtra. grind/fine, grind/course, grind/xtra........this continues for another dozen or so products. I have m2 rate in column 2, so I enter the data…
-
Resource view for multiple projects in a single sheet
I have couple of 'Resource View' questions... 1. Is it possible at all to use a single sheet to have multiple projects (as multiple parent tasks) and have 'resource view' to show the allocation against the parent tasks rather than multiple sheets? I need to see the break down of resource allocation based on these parent…
-
planned % complete
Hi guys, any advise on how works with % completed vs planned % completed as smartsheets only has column for % completed?, has anyone achieved to make a similar column for planned %?
-
Suggestions for Calendar Syncing
Hello, I recently had an issue with calendar syncing, you can see the thread here: https://community.smartsheet.com/discussion/resyncing-google-calendar As you can see in the response to the thread that a resync option isn't available. I had also had a conversation with Smartsheet support prior to getting a response on the…
