-
I cannot convert my if statement to a column formula
I have an if statement referencing another column named "Country" - I want to define this if statement into a Column Formula but it says "the column formula syntax isn't quite right". This is my IF statement. =IF(Country1 = "US", "01-440-0187 (US)", IF(Country1 = "Canada", "01-440-0188 (CA)", IF(Country1 = "Mexico",…
-
API Conditional Formatting
Hi - It sure would be nice to have the ability to update conditional formatting via the API. I see a thread from 2016 - is this something that the dev team could look at? Many Thanks, Sean
-
Preserve original formatting in automated alerts
Dear Smartsheet team, I found that the automatically generated table by Smartsheet and incorporated to email (generated as a part of Alert someone automation workflow) for some reason lost the formatting of cell, f.i. if on the original Smartsheet webpage the cell is colored in green and text is bold in email I see regular…
-
Lost of cell formatting (color, font type) in Alerts someone email
Dear users, I found that the automatically generated table by Smartsheet and incorporated to email (generated as a part of Alert someone automation workflow) for some reason lost the formatting of cell, f.i. if on the original Smartsheet webpage the cell is colored in green and text is bold in email I see regular font and…
-
how to transfer condition formatting from one row to other sheets (older sheets).
how to transfer condition formatting from one row to other sheets (older sheets).
-
Multiple delete/disable for conditional formatting
Currently, I have to click on each conditional formatting rule and click disable or delete on a sheet. Major use for a check box type list so that I can either disable, delete, or modify multiple formatting rules together.
-
Copy row without formatting
It would be very helpful if the automation to copy a row from one sheet to another could be done without the formatting going along for the ride. It's tedious to have to undo formatting from the source sheet in the target every time a row is added.
-
Need help with Form capabilities!
I am trying to create a temporary process for employees to submit time and expenses. There is a Entry Type Field that specifies which fields are displayed based on if it's a time or expense. For Time - I have logic set up that based on the date a new field will appear labeled as which day of the week corresponds to the…
-
I want to populate a Quote with information from a price list sheet
Hi Is there a formula or functionality that would enable me to to create a quotation using data from a price list on a separate sheet ? For instance on the price list sheet Column A ( SKU / Stock Code ) , Column B ( Description ) , Column C ( Unit Price ) . I want to fill the SKU / Stock code into the quote and have the…
-
How do I change a row color based on another rows date?
Hi guys, I am looking to change the text color in the row labeled "Projected Start Date" to red if the date in the row "Actual Start Date" is beyond that projected start date. I assume this is something that conditional formatting can help with, but I can't seem to figure it out. Can anyone help with this? Thanks!
