-
Smartsheet Merge Add-ons stuck on loading
Hello Team, I am trying to use Smartsheet Merge Add-ons to print a Row in a Web Form Layout. I have completed the steps but it does not work, Merge Data is stuck on Loading as shown below: "Smartsheet Merge will create 1 document in Google Drive. This may take several minutes depending on the size and complexity of your…
-
Report Builder - Not Sorting Dates
Hello - I running reports for partners on the team to provide the user a snapshot of tasks due earliest date to latest date. When I sort A to Z on the finish date it is not working. Any ideas
-
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
-
% 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…