-
Update Formula based on another field
Hello, Is it possible to have formula referred to a text in another cell to refer to the column to be used in the formula? Example: I have numbers of hours under each month column, against projects (e.g. ABC) in the rows. I have a metrics that sums up total numbers of hours per project for that month. =SUMIF(Project:,…
-
Workflow automation
Hello. I have a sheet setup with various columns. Each row represents a task that an individual is supposed to perform and select complete once they have performed the task. I want to create a workflow automation whereby when person A performs the task and selects complete, an alert or request for an update is sent to…
-
Circular Linking within Smartsheet
Can anyone tell me how to create a link in one cell on a sheet1 to a cell in sheet2 (I know how to do this part), but then allow the same cell in Sheet2 to populate sheet1 if a change has been made in sheet two? In other words, I want one cell to be changed in the opposite sheet if someone in one of the sheets updates the…
-
Possible to return original entered value in formulas?
Hi there! I'd like to use a simple IF expression to test a condition in another column. If that statement returns FALSE, I'd like to KEEP the originally entered data in the cell. Is something like this possible? The Unfilled column is a check box to indicate that a staffing shift is currently unfilled. If the box is NOT…
-
Automation occasionally works
I have set up automation to start an approval process every time a new line is added. That automation has worked without fail for the last 9 out of 12 months. It is the last three months it hasn't worked like it use to. Now in the last three months, if I use a form to add a new line to a smartsheet, the automation works…
-
Countifs Formula
I am very new to Smartsheets and having trouble with this formula. I'm sure it's something stupid like a " or a () but can anyone see what is wrong with this statement? =COUNTIFS((({LaunchYear}, Products142021"), (AND{Phase, Project Tracker}, "Title9"), (AND{status}, "Open"), (AND{Approval Column}, "Approved")))
-
IF/AND/OR Statements for date and status column
Hi SS Community! Very new to SS and clearly am not well versed in formulas. I need help turning the At Risk flag red when the Date Needed By is past due and the Status is Open or In Progress. Here is the best I could do... =IF(TODAY() >[Date Needed By]@row, IF(AND(Status@row = "Open", IF(OR(Status @row = "In-Progress")),…
-
Can a Start date and End date link from different cells to be on one line in Gantt
Hello! I'd like to create a master gantt chart where the beginning date is linked to one action in another sheet, and then end date is linked to another action in the same other sheet. For example, if I said Project A had an inspection and the inspection request happened on 3/31, but the inspection didn't happen until…
-
Is there a way to make an if formula case sensitive?
I need an if function to evaluate to true only if the cell it is checking is in all caps, but right now it evaluates to true if it is lowercase, is there a formula to do this? Thank you!
-
Smart Sheet Forms
Hello there, I need to capture information for a weekly status update, I am planning to use Smart Sheet forms to gather the status updates, and then consolidate those multiple rows into one single row. The challenge I am facing is that for consolidating all of the data in one single row I use the INDEX() MATCH() formula,…
