-
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…
-
Formula to display Red Flags
I am attempting to have a RED Flag populate in the "Risk" Column for cells where the "Available Space" is less than 10. Kindly when answering, please complete the entire formula from start to end as from research I tend to get bits and pieces as seen in my screenshot. Thanks,