-
External Collaboration & Communication (Outside Company Contacts)
If I send a written proposal through Smartsheet, as an attachment to an Update Request, and the client responds, I know that I will have an email verification, showing me any changes to the worksheet. However, at a future date, if our client wishes to send an approval verification through Smartsheet, they cannot use the…
-
Filters
Is it possible to add a field in the Filter to sort a to z. I would like to sort open items and by what is the nearest due date. Right now it's a 2 step process. Thanks.
-
OPPM_One Page Project Manager
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?
-
Contingency duration based on predecessors
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, to show dynamic contingency periods in my project. Let's take the simplest example, a project with the following three…
-
Report on Previous Entries
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% change as a percentage, or even an icon on a sight. Can this be done natively through the changelog, or would I have to…
-
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
