-
COUNTIF with 2 conditions
I want to count the # of projects in a sheet that are 'in progress'. there is a project status column; however the projects have children and i only want to count the # of parent projects in work without adding up their children. I was thinking of maybe doing a COUNTIF with 2 conditions, condition 1) countif 'in progress',…
-
Remove Mouse hover over pop up tool tips on menu bar ribbon
Is there an option to remove the pop-up mouse hover tool tips on the top menu bar ribbon? It is getting in the way of the feature buttons and has become very annoying. Thank you!
-
Auto numbering format in Web Forms
Hi, I would like to be able to create a web form that my supplier can use to feed back information into a sheet that isn't shared with them, on the status of a machine they have been asked to repair. When the machine is originally entered onto the smartsheet I've set it to Auto-number for tracing purposes. What I'd like my…
-
Submitter automatic approval email
Once someone submits a form, they receive a notification that says their submission was successful. Once the approval flow has happened, if approved how can I have the same submitter receive an approval email....or disapproved if that is the case. Is this possible if the submitter emails is recorded in a column?
-
Automated emails
I would like the ability to send an automated email to a sheet assignee at a certain time with attachments linked on that line in the smartsheet. preferrably I would like to be able to create a user group instead of a single assignee so that the email can be sent to multiple people but at this time it cannot be automated…
-
Sorting by date (ignoring blanks)
Sorry for the easy question. I've looked around and can't find the answer. I have a report full of dates, some of the dates are also blank. When I sort the column by ascending date, it starts with all the blanks, then the earliest date to the latest. when i sort descending, it gives me the latest date first to the…
-
Legend Totals
On the dashboard when I add a chart I would like the ability to include a total next to the legend item. For example, if I am doing a pie chart, in addition to seeing the total items represented by that color in the pie chart, I would also like to see the total items next to that heading in the legend itself for quick…
-
Allocating the % of the time can be worked during the day
I am trying to allocate the time that the employee can use for that task during the day to smartsheet. How can I for example if employee has 8 hours of work to do on one task, but he can only spend 50% of his day to this task. This means it will take him 2 days instead of 1 day since he can only work for 4 hours a day. How…
-
Update Alerts - Automation Workflow - Trying to Simplify
Greetings, I've created a tracking system and it's slowly coming together; however, one of the steps in my system is to send update requests to specific people based on the "Category" selected and based on the "Status" change. If the "Communication" category is selected and the status is "Green" it would contact person 1,…
-
Autofill of Duplicated Custom Fields with DocuSign
I have created a template in Docusign and connected to my SmartSheet account. I have a custom field for processes covered in the attestation letter that has a corresponding column in my SS list. When I create the envelope thru Smartsheet Labs, only one of my two custom fields is completed. What am I doing wrong?
