-
If statement % complete column
I want to create an if statement in my % complete column such that % complete goes to 100% when another column has a date.ย
-
Formula Refers to Worng Row
I have a SmartSheet that was created with nothing assigned to the primary collumn. This means many email notifications have no reference to what row or item it refers to. So, I added a formula to concatenate other collumns into the primary: =ID1 + " - P/N " + [P/N or Item #]1 + " " + Client1 + ", " + [Short Description]1โฆ
-
Dates Formula (IF?)
Dear, I need help I need a formula that activates a status dependent on a date. I mean, it automatically gets the corresponding color if a few days have passed after sending a quote. Example, if 3 days have elapsed since the date the quote was sent, the status should be automatically set to Yellow And if 5 days have passedโฆ
-
Feature Request: Programmatically access parent information from child in automated messages
A lot of the users consuming my automated alerts complain that the tasks don't have enough contextual information. For instance, "start marketing research" doesn't include the parent information of "Awesome Campaign #3". Need a way to include parent information in automated messages. For example, "Hi {{Assigned To}}! Theโฆ
-
Cross sheet Formula to pull in column value
Hello, I have aย Master Server Inventory sheet with columns such as Server Type, Server Name, Recovery Method,ย and several other columns with common data that has to be collected for all servers. I need to create a variety of separate sheets withย detailed configuration data about each server. I want to reference andย pullโฆ
-
Reference Another Sheet without Function
We use "Reference Another Sheet" quite a bit in our sheets. We do this by starting a function inย a cell, then putting an open parenthesis, then clicking on the link in the resulting dialog box that readsย "Reference Another Sheet" . This works fine. The thing I'm running into is sometimes I want to reference another sheetโฆ
-
LIttle Help With Formula
I have a helper column (checkbox) that fills the checkbox in if the "D/I" date is past 14 days...30...45, AND IF "install date" is blank. Here's the formula i have that seems to be working so far =IF([D/I]@row < TODAY(-14), IF(ISBLANK([Install Date]@row), 1, 0)) couple of ?'s... 1. If i fill in the D/I with a date, andโฆ
-
Month to Date and Year to Date spending
I have a sheet which contains date and amount spent, among other things. I want to show a MTD and a YTD metric on a dashboard. I am assuming I need to make a new sheet with a formula pulling data from the original sheet. I would like this to be ongoing as the original sheet is updated and then at the start of a newโฆ
-
Change status if progress bar changes (help w/syntax)
Hello I want the status to change if the progress bar is changed. I tried a formula but only have it half working. =IF(AND(Progress1 > "Empty", Progress1 < "Full"), "In Progress", IF(Progress1 = "Full", "COMPLETED!") This is the formula. I want the status to show either 'Not Started' , 'In Progress', or COMPLETED! based onโฆ
-
Formula that Automatically changes Date when cell changes
Is there a formula that would automatically change its date to reflect the dateย a cell or column changes? For example, I am creating a sheet where I want a formula that changes its date to reflect anytime someone changes the task, so the person changing the task's status doesn't have to change the date they updated theโฆ