-
Trouble with Formula for RYG/Health/Status Columns
Hi There, I'm brand new to Smart Sheet and still learning the abundance of inner workings - hoping to find some help with what is probably an easy formula but I can't seem to get it right! I'm trying to change the color of the RYG ball under my 'Health' column based on the 'Status' column. For instance: Red = Canceled/Not…
-
Splitting form data from multi-select field into multiple columns on sheet
I am trying to use SmartSheet to send out a form to vendors that allows them to select choices in a Multi-Select field. I then need to have the choices the vendors selected in the multi-select field split out into a binary type of indicator on multiple columns in the SmartSheet in order to use the data in a meaningful way.…
-
There´s a way to copy a row to another sheet with a if formula?
Hi everyone, i have a group of four sheets and i want to copy specific rows to another sheet. I have a column called "FORMAL RECLAMACIÓN" and i want to copy the entire row to another sheet if there´s a date on this column. Is this possible?
-
Conditional Logic in Smartforms (AKA Cascading Dropdowns)
We all love a Freebie? OUR API development team get lots of requests for automation which is the basis of our Smarter Mini Control Center 12 Apps, but one request we have been unable to fulfill so far (unless we use Appsheet with Smartsheet) is the need for Conditional logic or Cascading Dropdowns when completing forms in…
-
Task list for a card view? (like trello?)
We currently use a portfolio sheet that tracks our pipeline of clients and organizes them by stages. We love this sheet as it provides us with very useful management level information. However, it does not allows us to manage the "work". It just gives us an overview - which is the intention. To manage the work, we have…
-
Roll up of assessment data with conditions
I need to be able to roll up associated transmittal #s to 1 Transmittal and if the assessment status is Not Compliant for any of the Compliance Assessments then Transmittal 1 should equal Not Compliant, Transmittal 2 = Not Compliant, Transmittal 3= Compliant
-
HOW TO SOLVE INDEX MATCH WITH DATE TENURE?
This is Table 1 This is Table 2 The criteria is Match the Date & Name from Table 1 to find the Amount and put it in Table 2. And also add the amounts which is under the date tenure for the specific month. After many research I have found a formula which can mach 2 criteria at once but its not working for add the amounts…
-
How can I use two conditions to return a specific result in another column
I am working on creating a form for stakeholders to complete that will populate a smartsheet that we've had in place for several months. This would create efficiencies for us and help our stakeholders as well. I want to be able to do the following: When a specific selection of department is made, and the spend amount is…
-
Can we setup incremental synchronization for SmartSheet API
I'm in need of performing incremental synchronization for REST API to fetch only the recent data of endpoints in general like recently added comments,rows,updated requests after a specfic time stamp,
-
Dashboard Calendar
Hi, I was wondering if someone would be able to point me in the right direction as to how you can create a dashboard calendar that can be displayed for everyone who has access to see. This would be used for project management and to track tasks and their completion dates. Kind regards, Sync
