Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please
Visit the Current Forums.
how do i put columns down left handside of sheet
Still Looking for an IF function that does nothing to the cell if False
I asked about this back in April and got a few suggestions but nothing that really worked for me so I'll try again. I keep track of the hours charged to around 35 projects by people in a dozen functional areas on a weekly basis and send the monthly total into our finance team for their revenue recognition process. I use…
reassign to colaborator or anyone else?
When I reassign a taks to a colaborator, is it possible that the colaborator (or anyone else) receives a message (email) so that he/she is aware of the task?
Status Order Tracking (similar to the Dominoes Pizza Tracker)
Was wondering if its possible to create an online sheet for my clients to be able to get Status updates? Ideally I would want them to go to an online sheet and put in their Invoice number and it will tell where their job is at (With Designer, Proof Sent, At the printer, Completed etc.) Does anyone know if this is possible?…
Auto-generating username making the change
is it possible to have a field which has the name of the user that last changed a row?
Ideas for Multi Department Service Request tool
All, We are currently using Smartsheet as a Help Desk Ticket system for one system, with two developers and two users that submit bug or enhancement requests. A webform is used to submit the request and email alerts and conditional formatting are used to track the status of the request and notify users when anything…
Emailing a report
Hello.. I have a report set up to run every Monday to show uses a list of their "issues". Is there a way to skip the email if the report is blank? Now it sends a blank attachment Any ideas? Please let me know Thanks!
Web Forms and Dropbox
Can I save a web form to a Shared Dropbox folder so my client has access to it. They always lose the link and ask me to resent it. How can I prevent this from happening
I would like to use Smarsheet to track task times
I have three cells (1) Start1 (08:00) | (2) Finish1 (08:45) and (3) Total Time How do I calculate the total amount of time from start to finish in the Total Time cell? I tried this (=Start1 + FInish1) but this concatenates the two values and doesn't add them up. Any help would be appreciated. I'm interested in tracking the…
Send row and update request to the resource assigned to the task
Hello, Is it possible to send the row or the update request to the resource assigned to the task instead of enter the resource manually? All my tasks have a resource assigned and every resource has the email defined in the contact list. However, every time that I need to send the row or the update request, I have to enter…