-
Formula to return data from last row of a sheet of data
I am working on a dashboard and I'm using a intermediate sheet to collect data from other sheets of data. Typically the data is entered in each day so I was able to have the formula for most cells to look at the referenced sheet and return the value for the row of data by date =SUMIFS({Incidents YTD}, {Yesterday}, "1").…
-
Phase of Work Formula
Hello Community- I am looking for help with a formula to tell me what phase of work the project is in. The formula will be looking at 5 checkboxes in columns. If I complete the last checkbox in the first phase, but have not completed the last 2nd phase checkbox, I would like the column "Project Phase" to return the 2nd…
-
API access token queries
Hello, We currently access SmartSheet Sheets using the latest version of the SmartSheet SDK. In our use-case, the plan is that only one person will create Sheets. It is this person that will have created the access token. There is only one application using this access token. This application is configured with the same…
-
IF FORMULA TO PUT AUTOMATIC STATUS
I would like to know what can I do to put automatic status for my monitoring sheet? There are 3 status: In Transit, Cancelled and Delivered. I want to know if its possible that when the requestor input the delivery date (refer to the screenshot), the status will change to "Delivered". For the Cancelled and Transit though,…
-
Copy contents of a cell into Comments
Is there any way to copy the contents of a cell into Comments? Or have comments on a specific cell? Or show the value of the last entry in Comments in a cell? Thanks.
-
Alerts Not Sending
I have created a very simple alert to alert me when anything changes on a sheet. But, changing data is not triggering the alert. Are alerts down?
-
Service Down
We need more details than what is on the status page on the current status of the outage. Customers rely upon this software and we need more info on the progress.
-
Creating a Chart from Non-Numerical Data for a Dashboard
I would like to have a pie chart on my dashboard that displays percentage of types of activity from a column in a sheet. More specifically, I have a column in an IT tracking sheet that has a dropdown menu. I would like to be able to display on a dashboard the percentage of each activity in the sheet. (e.g., a pie chart…
-
Index, Match, Parent
I'm trying to dynamically change a cell's value depending if a checkbox is checked or not. Directors of a project would like to know what stage a project is at and if that stage is on target or not. Where I'm running into trouble is the directors only care about the Parent Task and not the child tasks. This is what I have…
-
Smartsheet - Salesforce Connector
Context: In Smartsheet, I have a project intake sheet with many columns of data related to each project. I have set up a workflow in the Smartsheet-Salesforce connector that routinely syncs over relevant data from Smartsheet to Salesforce opportunities and vice-versa. Problem: I am having trouble syncing over the column…