-
Day & Week before reminder
Hello, I would like to set a day before and a week before reminder that references a Due Date column I have in my sheet and only triggers on weekdays. Is there a way to do this? Thank you for your help!
-
automation for adding date?
So I'm fully aware of the automation to add a date when a cell is changed, but it doesn't seem to be working for me. Hoping someone might point out where I went wrong. I have a grid of teams and members where I keep track of which members are complete, I'm trying to track when a 70% or more of the team is "done". I've made…
-
Wrike/smartsheet Integration?
One of our departments made a decision to get Wrike last year. They've told me it can integrate with smartsheet- but I haven't found anything that explicitly gives how-to kind of guidance or is it just an API kind of thing where we have to pretty much develop it. I hope to show the team all the great new functionality we…
-
IF Formula Question
Hi there, I am kind of new to SS formulas and I am trying to create a function that adds an amount to a column IF that column is a certain deal type. The columns that I need the addition to are labeled "Development WAG $" and "Implementation Costs $". IF the "Deal Type" column has "Lease/ Purchase" I need the $350,000 to…
-
Timestamping
Hello. Is there currently anyway to do timestamping in Smartsheets? For instance, timestamping a cell when a tick box cell is ticked? Thanks Andrew
-
Default Conditional Formatting and Options, is it possible?
Hello everyone, Is it possible to add a default Conditional Formatting to every existing sheet and every new one.? I would also like to set the Options % Complete column to always be set as % Complete. Is that possible or the way is to do it individually?
-
Formula for calculating today minus the case created date
Hi, I'm a new user here. What is the equivalent formula from google spreadsheet to smart sheet if for example, C2 is the cell with Case Created Date? =TODAY()-C2 I'm trying to show the actual case age without including the weekends and holidays. Thank you in advance for the one who will answer.
-
Set up conditional formatting in dates, with additional variants
I know how to set the conditional formatting to have a date cell turn red when the task is due in the next X days (for example). But is there a way to do it only if the Status (another column) is not in "Complete"? So something like: If Status is "In progress", "In review", or "Not Started", AND Due Date is in the next 2…
-
Conditional formatting to highlight attachments on a row
As the attachment (paperclip) column is on the far left of the sheet and can't be repositioned, it's not always clear when an attachment has already been added to a row (as I often don't scroll far left to check, especially in sheets with multiple columns). Is there an easy way to use conditional formatting to identify and…
-
Formula to check a box depending on start & end date
Hi all, I have 2 date columns (start date & end date) and 2 checkbox columns (live & concluded). I want to have the checkboxes automatically check and uncheck depending on the dates. For example: I have an event that runs from 12/2 through 12/4. On 12/2 I want the "Live" column checkbox to check and stay checked until the…