-
Smartsheet reminder/alert via SMS
This discussion was created from comments split from: Smartsheet reminder/alert via SMS.
-
Removing Zero from my results
Can anyone see what is wrong with this equation. Trying to remove zero from my column when nothing has been done. =IF({08 - Estimating # of Pricing} = 0, INDEX({08 - Estimating # of Pricing}, MATCH([Job #]@row, {08 - Estimating Sheet Job #}, 0)), "")
-
Formula Functionality: RYGB Status Change Based on Date
Hello! I have reviewed Smartsheet Discussions quite a bit, but this is my first post. I am trying to correct a formula I made to change RYGB statuses. Currently the status correctly changes based on the following: Blue if a Date Resolved is entered. Green if the # of calendar days is > or = to 15 days. Yellow if the # of…
-
[UPDATED] Community Reward Program 🏆
Hello Smartsheet Community, We value the way you support and encourage one another and want to recognize your efforts with our Community Reward Program. As you engage with the Community you'll level up and unlock rewards including swag, and access to previews and beta features. Curious? Read on to learn more about our…
-
Return value at the intersection of a row and column
I am new to smartsheet and haven't found what I'm looking for through search. I have a sheet that is contains a table of cycle times. This table is for reference and the values in the table will be used in a different sheet. I want to be able to return the value that is at the intersection of a row and column based on two…
-
Transforming data from Oracle DB to Smartsheet grid/table via Azure Data Factory
Hello, I am looking to grab data from my Oracle DB, transform it to an acceptable data format for Smartsheet to take in, and present it in a table format using Azure Data Factory. Does anyone have any working examples, articles, etc that I could feed off of?
-
Child statuses in parent row- combined from more than 1
Hi Smartsheet Heads! Currently I am using a formula from this thread: https://quip.com/nyDjAzhAKRhq =IF(COUNT(CHILDREN([Localisation Status]@row)) > 0, IF(COUNTIF(CHILDREN([Localisation Status]@row), "Approved") = COUNT(CHILDREN([Localisation Status]@row)), "Approved", IF(COUNTIF(CHILDREN([Localisation Status]@row), "Not…
-
Stop Workflow with Action
I keep receiving the reminder notifications for a flow. I added an action at the end of the flow, but I still receive the reminders.
-
Alert Triggered by sum threshold on a specific cell
Hello all, I have a need to alert the person in charge of the spending when the total spending reaches a certain threshold. Actually, multiple levels would be ideal. The source sheet pulls invoice totals from several other sheets and adds them up on a monthly basis. After the calendar month is over, this sheet will…
-
Is this a Bug or a Feature?
Hi There, Trying to figure out if you have a column set to dropdown and allow multiple values per cell, when you go to create an automation for it, is it suppose to only let put it in as a if it changes only?: why isn't it like a dropdown without the allow multiple values per cell on: why can't I select a value in the…