-
Automatically add emails into smartsheet
Is it possible for an email to automatically be added into a smartsheet? Just like a form entry gets added, can someone send an email to a particular email address that is automatically added to a smartsheet? I saw an old post about this from a few years ago but want to know if this is something that can be done now. It…
-
Removing Single Cells
Hello, I am looking to remove a single cell from a grid and have the cells underneath move up but I am only given the option to remove rows which disrupts formulas I have in place. Is this feature of removing single cells available?
-
Requesting scheduling for events that show up in calendar view
I'm using Smartsheet to request things through different processes in our organization, but one request process that is giving me headaches is requesting after hours air conditioning. We use building automation to control when air conditioning runs, and people have to request A/C if they are using a facility when the A/C…
-
Reports pulling through duplicates columns
Hi All , We have setup a master project portfolio dashboard (master sheet ) which is fed by multiple sheets (Child ) . The calculation for the dashboard is done via a calculation sheet as shown in the attachment . The on click function in the dashboard opens a report showing high priority projects for instance . The issue…
-
create graph based on cell history
Hi, I need to create a graph that track history of project evolution / execution. So, I need to have a report that contains the date that %completed was changed and the % that was added so I can create a timeline / evolution graph based on this info. How can I retrieve this info from cell history in an automated manner and…
-
Tracking variances between baseline and actual dates
Hello, I have copied a plan into Smartsheet from MS Project and have followed the instructions in https://www.smartsheet.com/blog/smartsheet-tips-tracking-baseline-schedule-variance to set up a means of tracking the variance between baseline and actual start and end dates. However the message # Invalid Data Type appears in…
-
Feedback Submitter Count
I have created a Feedback intake form and a Dashboard. In the Dashboard I would like to chart total count of submissions by each submitter name. I do not have a list of those who will submit but I know they will submit multiple entries. So I want to be able to count each of their respective entries. Lets say John submits…
-
Create RYG Balls for Children
I've spent hours attempting to display RYB Balls for three different drop-down status. "Not Started" "Pending" "Signed" The goal is to have a "Red ball" display in the Not Started Column for the drop down "Not started" in the Quote status children. The formula I'm attempting to adjust - =COUNT(CHILDREN([Quote Status]2 =…
-
Enhancement Request: Filters to include and / or functionality
I would like to request the ability to customize filters by adding specific conditions to each row. The filters currently have an option to show rows that match all conditions or an option to show rows that match at least one condition. Because we share our SmartSheets with multiple teams, I would like the ability to add…
-
Submitting a row to two sheets broken by SDK updates
We have a form on our site that adds a row to two sheets in Smartsheet. This broke in June at which time the form added a row to the first sheet, but failed in the API call to Smartsheet in adding a row to the second sheet. Example Code that submitted to the first sheet (this was not affected): protected void…
