-
Update requests
Hi everyone, I have built a sheet in smartsheet to track supplier performance. When there is an issue with their performance, I am wanting to send the supplier a update request in order for them to provide corrective action for problems and it to be written directly into the sheet. This works great but to provide context…
-
Conditional Formatting on Web Forms
Does anyone know if there is a way to implement conditional formatting on web forms? For example, if I have a web form to populate a sheet, I want to be able to implement rules to email certain people based on a specific value selected in a drop down on the web form. I did try to figure this out using Zapier, but couldn't…
-
Why doesn't adding a comment to a sheet highlight the 'SAVE' button?
When I add a comment to a sheet, the "SAVE' button stays greyed out. This makes me think that comments won't be saved unless I do an additional action that enables the 'SAVE' button and then click the 'SAVE' button.
-
Same Project, Different client (COUNT Formula)
Hi Guys, Can anyone help me do a formula for the smartsheet that I am working on (please see belw attached Pic). In the table, it indicates that there is a same project with different client, different Received and Sent Dates. I would like to come up with a Count (or other possible) formula that will result to counting the…
-
Chart on Sights
Hi, I created a chart on SS labs. I want to display the chart on my project dashboard. How can I do this? Y
-
Add criterion to SUMIF
Hi, relatively new to formula. I am calculating daily time spent on projects and have set up a SUMIF formula to do the job, which is work fine. =SUMIF([Job Date]:[Job Date], DATE(2017, 3, 1), Time:Time) / 60 I now want to add a criterion to calculate the time spent on a project by each team member [Assigned To]:[Assigned…
-
Staff Holidays
Hi, Does anyone know a way of linking staff holidays with Smartsheet. I know how to set up public holidays but, want to see when individual employees holidays effect resource management? Many thanks Faye
-
Simple Performance Review Template?
Hi, Anyone that can help? I found the themplate: 'Simple Performance Review Template' on this Smartsheet website: https://www.smartsheet.com/free-employee-performance-review-templates But I can't find the template in the Human Resource category within Smartsheet. Any suggestions? :-) Kristian
-
New notifications great, but still missing..............
The option of when I "save as new" the new sheet doesn't copy over the notifications/reminders. As I roll about 20 sheets over each month, it is time consuming to set up all of the notifications/reminders. Please add. Thanks
-
ABSOLUTELY IMPERATIVE - DEFAULTS FOR FIELDS
This is a MAJOR fail - that while you can set a field to a default value in the form, you can't do it in the sheet itself - !!!!! this is a FAIL! This should be addressed as soon as possible by your team.
