-
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…
-
Enhancement request - search visible rows only
Is there a search option that will only return results for visible rows? I'm trying to search for something and I don't want information contained within hidden rows to be returned.
-
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,…
-
emailing a form once a checkbox has been activated
Hello out there in smartsheet land, I'm trying automate an email of a survey form. I want the form to be emailed once a check box has been checked off. I've checked the formulas page and I cannot find the help i need . Any help would be greatly appreciated. thanks Donny
-
SUMIFS - Criteria person's Name & Date to SUM 3rd column with numerical value.
Purpose: To sum the hours worked per person for a given week. COLUMN 1: Name COLUMN 2: Date COLUMN 3: Hours (Integer Format) 2 independent SUMIF formulas working, but not SUMIFS together. FORMULA 1: =SUMIF(Name:Name; "Sid Organe"; [Tsk-Hrs]:[Tsk-Hrs]) Working FORMULA 2: =SUMIF(Date16:Date46; IFERROR(WEEKNUMBER(@cell); 0) =…
-
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
-
Edit content in Sights.
I just started using sights. I see that it is not possible to edit individual cell directly from sights, or am I mistaken? Is there a way to do this? It would be very helpfull if I could. I would also love to be able to edit the comments field directly from sights as well. Is this possible?
-
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
-
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