-
AND statement in smart sheet
I am having issues getting results back when using AND statement I am trying to compare two conditions, and show if an action is late or not using the following formula I want to say if the End date is before today and the completed is blank then the action is late. the line circled in red should show 1 cause both…
-
Trigger Issue
For one of my sheets, when someone submits a request through a form, I have some rules that assign approvers, and also some rules that assign the number of approvers. These always work fine. Okay, as one example, let’s suppose the number of approvers is just one. I have a Change Status rule like this: When rows are added…
-
Assigning an auto-number
Hi I have a sheet that is populated via a form and if questions are answered in a certain way it copies cells to another sheet. Once the row has been copied to a the other sheet I have other update workflows that are triggered. The problem I am having is I need to be able to assign a unique ID to the row being copied, but…
-
Admins cannot Edit our Smartsheet after sharing permissions changed
We are on a Pro Plan account with one license. We would like two people to have the ability to edit and add data to a Smart Sheet. We have granted them editing permissions and then tried giving them Admin permissions. They are both unable to edit or input any data in the smart sheet. The two people we wish to give System…
-
Display RYG based on calc of two sheet summary fields and IF/OR statements
Hi, I'd like to display Red, Yellow, Green in a Sheet Summary field based on the calculation of two other fields, Past Due and Total Tasks. I'd like it to show Red if Past Due divided by Total Tasks is greater than 60%, Yellow if between 40% and 60%, and Green if less than 40% I'm new to Smartsheet so could be way off:…
-
Formula help - reference data from 2nd sheet, with conditions
Hi, I’m looking for help with a formula for my sheet. Images of my sheets are below Goal: I want to auto-populate the Holiday column in Sheet 1 with data from Sheet 2, based on certain conditions. Populate Sheet 1 Holiday column with data from Sheet 2 Holiday column, only if: Sheet 1 Date matches Sheet 2 Date, AND Sheet 2…
-
Count Cells that begin with a specific text
I wanted to COUNTIF the number of cells that start with specific four letters in a column of a reference sheet. I used the formula below and it returns zero. =COUNTIF({Reference Sheet}, "ABCD") Is there a formula to return the number of cells that have the first four letters as "ABCD"?
-
Using smartsheet-python-sdk to put data back into Smartsheet
I used the smartsheet-python-sdk (and unique API key from Smartsheet) to automatically pull data from Smartsheet into my Python script along with other data sources to create new feature-engineered columns. Is there an automatic way to now put these new columns I created back into the same Smartsheet I initially pulled…
-
Shared filter not working for other uses
Hi, I have created a shared filter on the Smartsheet sheet so that people can see certain projects only, and with the other projects being hidden. The filters hides the other projects on my sheet however it does not automatically hide them for other people. I have about 30 people using the sheet and it won't be practical…
-
Calendar View on a Report won't allow us to make comments
Hi, we have a Delivery Report which takes info in from approx. 50 Project Delivery sheets. If looking at the Report in Grid View we are able to add comments to all rows/sheets but when we are looking at it in Calendar View we aren't able to add comments to the vast majority of rows/sheets. There seems to be one sheet which…
