-
Include update request button on Alerts
Hello, Is there a way to include the update request on an email alert? We currently send our customers a notifications when they submit a request. What we would like to do is give the customer the ability to update the request without giving them access to the sheet. We also do not want to manually send an update request…
-
Clock Hour Progress Management
Hello, My name is James Smith. I am an Instructor for Gateway Community College in Phoenix, AZ. I am Looking for alternative methods to track time as student’s progress through our courses. I am not looking for a time management system, just a tool to enter a student’s hours into a spreadsheet or software to help me manage…
-
Printing cell history value
I have A1 and B1 which are two different dates (for illustration: A1 is today's date, and the other in the following day). I have data value in Cell C that is changed daily by another cell linking formula from other sheet. Then I have cell A2 and B2 -- the formula in these cells is: =IF(today()=ColumnA1,CellC) and…
-
Track Task Delays
I want to track how long an open task is delayed on a project
-
Login and Display Issues with community
I have been experiencing several issues with the community over the past few days... from all of the profile badges appearing as links, to being prompted to sign in when I already am. Not sure what is causing all the havoc, but I thought I'd make ya'll aware.
-
Looking for form creator - most secure and customizable
I've played with Google forms but don't like it's lack of customization and am not sure about the security. Are there other programs that are more secure that integrate with Smartsheet?
-
Want to track resource allocation
Has anyone had any luck with this? Want to do something similar to the features in Microsoft Project. I have a lot of design projects going on and want to be able to allocate resources (my designers) to projects and be alerted to when a resource is exhausted. Has anyone been able to figure this out? I would really…
-
Formula does not always recognize "" for blanks?
I have an odd one that hopefully someone can shed light on as i am going a bit crazy :) I finally figured out a formula i have been working on for few days ... strangest thing it seems to have been the quotes that i was using ??.... I used the quotes (directly to the left of the enter key with shift ) as a blank and i…
-
number of days between one state and another (not including weekends)
I need to include a column that shows me the number of days that a person maintains each state (not including weekends), if you don't enter the form every day to update the information. Could someone help me with this? date of creation| Name | Status | DAYS WITH THAT STATUS 03/03/2018 | cristian | busy | 1 02/27/2018 |…
-
Reporting and dashboard help
I have a smartsheet containing work experience for every person in our company. The rows go something like this... * Steve Smith | Project Manager | Company A | 2.5 years | etc... * Steve Smith | Project Manager | Company B | 1.5 years | etc... * Steve Smith | Project Coordinator | Company B | 5 years | etc... * Karen…
