-
SUM of consecutive cells until blank cell is reached in the column
Hi, i am trying to SUM any given number of consecutive cells in column A and need it to stop once a black cell is reached. For instance The SUM will be column A, row 2 to 6 (7 is blank) and I am wanting the SUM to display in column B row 1. This will repeat throughout the sheet, but the SUM result will always be column B…
-
Automatic Move
One of the ways I use smart sheet is to manage my work load. Once a project is completed, I move it to a completed row to keep record of it. Is there a way to automaticaly move a row once the staus has been change to "completed"?
-
using start and end time columns to calculate hours worked for a timesheet page
i am trying to track staff hours by having them complete a web form to auto submit their timesheets. i need to be able capture start and end times for any given day so i can check how many hours they have worked. any suggestions?
-
Card View - printing/exporting?
Good afternoon, Is there a plan to allow printing/emailing of the card view? This would be of great benefit for our team. Blessings, Loann
-
importrange function
We use the importrange function reguarly within our Gsheet implementations, and would like to allow certain cells in smartsheet to receive regulary push updates from an active gsheet via this function. Is there a way to do it? In example, we have a productivity tracker in gsheet that is calculating various % complete…
-
Managing dropdown list selections from another sheet
Hi all... My company has an ever-evolving list of clients. I'm looking to utilize a dropdown list for users to select the client instead of asking them to type it in (eliminate keystroke errors and inconsistent naming). Being the client list is frequently updated, is it possible to manage this through a separate "linked"…
-
I would like to change a cell if an attachment is received
I need to send reminders to suppliers for them to attach specific files such as datasheets etc. Once the file has been received I would want Smartsheet to stop sending further reminders. I think possibly a solution is for a cell to change status if an attachment is received. I could then create a logic statement which will…
-
Calendar view in Sights?
I have a report that I use as a "Master Calendar" for vacations, major milestones, etc. How can I put this into my Sight dashboard in "Calendar" view? When I insert the report as a widget it only allows it to come in as "Grid" view. Thanks, Armen
-
"Other Sheets" in Resource View & Error message
For certain users, a non-hyperlinked row called "Other Sheets" is listed, and has overallocated that resource to 300%. Unfortunately, since it's not hyperlinked, I cannot see what sheets/tasks the resource is assigned on to resolve the conflict. What does "Other Sheets" represent? Is is from resource-enabled sheets that…
-
Re-using Update Request Links
Is there a way to re-use an Update Request link? For example, if I opened an update request and I am not ready to post a response, is there a way to open the Update Request again? The Update Request link is a one-time only link right? Is there a way to work around that? Thank you
