-
Approval Workflow
I created a workflow. The screen shot is attached. I was trying to see if when ready for approval is checked can approval status automatically change to submitted? How is that done if possible?
-
Does SmartSheet support any CURL to get the total row count in a sheet?
I am using curl with REST to access Smartshets in my C# running on WIN CE. My application is supposed to dump some data on smartsheet periodically. Before I write to a sheet, I would like to know the total row count in the sheet so that I don't exceed 5000 rows per sheet. I am looking for an API that would return just row…
-
Strip Time When Linking Max Modified (Date) Cell to Column with Restrict to Dates
Hi Smart Sheet Community! I am applying a formula to a cell in our project schedule sheets that I found in a couple posts to grab the MAX value of the Modified (Date) column: =MAX(Modified:Modified) + "" My colleagues and I will be linking the cell with this formula from our project schedule sheets to a "Last Updated"…
-
Nested IF and
I trying to use to create a sheet that I will use to determine the status by comparing 2 status and then give an answer the e.g. If the status1 is low and status 2 is low the actual status should be low, I used the following IF/AND Statement and it worked fine: =IF(AND([Status1]3 = "Low"; [Status2]3 = "Low"); "Low"; " ")…
-
JOIN, COLLECT with MATCH
In Sheet 2, I want to JOIN and COLLECT a group of values from Sheet 1, separated by a comma. I have this figured out: =JOIN(COLLECT({AutomatedCourseCopy-CRN}, {AutomatedCourseCopy-CRN}, <>"", {AutomatedCourseCopy-UseinBCC}, <>"", {AutomatedCourseCopy-College}, CRN1), ", ") + "," I have a set of values in Sheet 3 that…
-
Adding a new Column to multiple workbooks
I have used the same template to create a tracking system throughout our company and now have 25 sheets. I have been asked to add a column to the template and all existing workbooks. Does this need to be done manually one at a time?
-
Link to a Google Drive Sheet from a Dashboard
While I have tried everything, it seems, whenever I click on my newly-created dashboard item that links to a Google Drive Sheet (Google Sheet), it is asking users to "open with?" Is there a way I can have users click my link and go directly to the interactive sheet without choosing anything?
-
Linked Sheets for Templates
I believe this is an enhancement request but I see it is always good here to start the conversation in the community to test the appetite before requesting it, and it seems it gets picked up by staff more here. I am creating project templates in smartsheets for our project managers. I am doing this by creating a 'Master'…
-
Auto group like cells
Is there a way to auto group cells that are the same, and add a count of them next to the parent cell? For example, I have a sheet that looks like the first screenshot (ex1), it's a list of SKUs within a program and a project. I want to group all SKUs within the same program/project and count the number of SKUs (see ex2).…
-
Is there a way to prevent users from moving on to next cell...
...without entering a value in a particular cell? For instance, I want to make sure that users enter a ZIP CODE is a row - If they do not, I would an error/warning to pop up or, at least, inability to save the entry without entering the ZIP. Any suggestions?