I am new to Smartsheet I am a big fan of communicating task and project status via a single page. Does anyone have experience of using Smartsheet using the OPPM format?
I was wondering if it is possible to create a task whose duration is determined by two predecessors, one from backward planning and one from forward constraints. I would like to use this, among others…
Hello! I'm curious what would be the best way to report a cells previous vs current value. For example, last month we had a status set to 15%, and this month it's updated to 20%. I'd like to see the 5…
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 differenc…
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.
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)…
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 g…
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…
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: =…
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 …
