-
Integrate with Outlook with Dates and Times and Assignee Information
The outlook integration as it exists is nice if you only have one or two projects. As a single user I manage hundreds of projects at a time I would like to be able to sync my calendar to outlook in a more integrated format. For example, when i set a task or appointment date in Smartsheet I would like to be able to…
-
Linking Sheets in Workspace, Cell Pull through based on conditions
I am creating a series of sheets in a workspace. The idea is that there is one master log that feeds other logs as it is updated. The child logs would be fed once a condition on the master log is met, the kicker is that I don't want a line for line transfer leaving me with blank lines if a line on the master log has not…
-
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).
-
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!