-
Looking to Hire Smartsheet Help
Hi all, I see so many great features with Smartsheet, but have been struggling with having the time to learn the program in order to properly use it. Wondering if anyone with excellent knowledge of the program can offer their services to help me set up some project management and product management templates that I can use…
-
Building Sheet to Alert Past Due Items
Hi All, I am trying to build a sheet that will track when items are turned in to our billing department. If the "turned in"date is past a certain date then I would like for the sheet to send a notification to certain people. The only thing is the "turned in" cell will remain blank until the date it is actually received. Is…
-
Problem saving a large sheet when insert/remove/move rows.
I have a large Smartsheet with 1472 rows, 30 columns and about 27,200 cells with formulas, mainly IF() functions plus three simple conditional formatting rules. The page will load in a few seconds and simple changes save in a few seconds but if I insert or delete a row near the top of the sheet, or move some rows from near…
-
Add date/time stamp of when another sheet was updated?
Is there a way to add a date & time stamp to a cell showing the last time the sheet was last updated and saved?
-
Worksheet Content Protection
Dear Community, Is it possible to hide and lock a specific section (rows) of a worksheet, so that only Admins and specific nominees can unhide and modify them? The data within this section is commercially sensitive, so only a few users will need access to unhide and edit. I would rather avoid the need to separate out to a…
-
Formatting data in lower right corner
Hi, I have a very simple suggestion: Smartsheet should format the count, sum, and average in the lower right hand corner (when multiple cells of data are selected, see scn shot). It is very difficult to tell the sum of a large number without commas. Thank you, Max
-
Cash Flow Projection in Projects Sheets
Hi, I am using =IF(AND( ... )) to project in which month a disbursement will be made in a project planning sheet. Does anyone use an easier faster way of scheduling disbursements and depreciation? Regards
-
Duration in a summary task show "hours" instead of "days"
I have a series of sub-tasks in minutes and hours but then the summary task shows the duration in days. It is frustrating to not be able to change that, is it possible or could that ability be added to change the duration display in summary tasks? Thank you, - Blake Chesley
-
Is it possible for summary bars on Gantt to be subject to conditional formatting?
Okay - My conditional formating on this sheet is set to change the color accross the entire row and bar. If status is checked, the gantt bar goes to grey, if not checked, it stays green. The summary bars are not changing. Is this possible? Thanks Jef
-
Continuous Links between Sheets
I have a master (parent) sheet linked out to several child sheets, the master effectively pushes header information out to the child sheets. When a new row is added to the master, the child sheets fire off a notification to various teams requesting their input. This may not be the most efficient setup but it currently does…
