-
Turn on update request replies email
I have a SmartSheet and I regularly send out update requests. When someone responds to the update request, I'm not getting the email notifying me of the update. How do I turn that on/insure that I get the emails? Thanks so much, Janet
-
Use formulas in percent complete column with dependencies enabled
I have a formula in my percent complete column, but when I enable dependencies (in my predecessor column and duration column) the formula gets wiped, leaving only the value behind. Is there a way to keep the formula when enabling dependencies or is this just a limitation of smartsheet?
-
formula to distinguish decimal versus percentage (i.e. 1 versus 100%)
I have a report that combines many sheets. Sometimes the values entered as 1 rather than 100% (or .75 rather than 75%). The report is an input into Tempus (Smartsheet partner) and it makes a difference to their application. Is there a way to determine that a value is NOT a percentage? Or require entry of a percentage, or…
-
Forms Enhancement Request
I would LOVE if Forms could be accessed outside of the sheet. Grouped together the way that Reports, Sheets and Sights are. Is this possible?
-
Automate from Google Form to SmartSheet to 2 Documents?
Is it possible to auto generate 2 documents from within Smartsheet when ever a new response comes in? Client fills out Google Form Response is stored within SmartSheet automatcially 2 Google Docs are generated and place in two different Drive folders Possible?
-
Shortcut list in Sights
If I want to add a widget which shows clickable links to Word document files in Sights (shortcut list), is it possible? See the snapshot below. ( I found this snapshot at https://www.smartsheet.com/how-create-dashboard-excel)
-
Email alert when not modified
Hi All i have created a card view that are work packages for staff, i am requiring them to update the cards every 7/14 days with status and commentary. is their a way to build an alert that sends an email to either myself and/or the assigned staff member that lets them know the card has not been updated, additionally in…
-
Update Row background with API
Does anyone have any C# code to just find a row and update the row background color (highlight the row). I have it on another program, but because my rows have System Cells (Created By & Created Date) I have to completely rebuild the rows with the cells before I can apply the format. I was wondering if there was a quick…
-
Project Management
Hi, we currently have a few web forms, that allow clients to request quotes. These then populate fields on a smartsheet as normal. We have two challenges that I'd like to implement but can't seem to get it right. We would like to give the client more visibility on the status of the opportunities, but for various reasons,…
-
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…