-
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…
-
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
-
Web form Alerts Not Working
Hi, My webform alerts do not seem to be working. I have set up a IT Helpdesk tracker using a template. I have included a hidden column that is checked by default when a new line is added via the webform. I have set the notification to the right column and have send the notification to a shared user. No email notification…
-
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
-
Round to nearest 0.5
Hello, We are building a time management sheet based upon a simple Smartsheet feeding information from a Form. After we've received the information we want to round the calculated results to the nearest 0.5 (see screen capture) The data we receive are collected and calculated in plain text/number columns. The Round formula…
-
Is there a way of allowing Editors the capability to Sort Rows?
I have a Current User report available consolidating many projects into one so it doesn't become overwhelming to the users. But it seems they have no way of Sorting is there an option for this? Other then Admin doing this?
-
Smartsheet Sorting
Hi, Is it possible to sort data without having it sort the first two rows of data because the first two rows of data are my column titles. My column titles are just repeats of the smartsheet column titles. Thanks! Kevin Au
