-
function to show current on-call employee from schedule on separate dashboard
I have our team's on call schedule on smartsheet, and i want to display the individual's name for who is on call this week on our team's smartsheet huddle board. I am assuming I am going to use the IF and VLOOKUP functions (possibly the TODAY function), but I don't know the correct syntax to use! Goal: cell: row 1,…
-
Assign value to another cell
Hello, I have a form that includes the following fields: Company Contact Name (text field) Supervisor Name (text field) Check if supervisor is the same as the company contact (checkbox) How do I copy/paste the Company Contact Name automatically to the Supervisor Name if the checkbox is filled? I've tried using a formula…
-
How can I add a return Blue if all these arguments are false?
IF(SUM(ColumnA@row) > (ColumnB@row + ColumnC@row), "Red", IF(SUM(ColumnB@row) > (ColumnA@row + ColumnC@row), "Green", IF(SUM(ColumnC@row) > (ColumnB@row + ColumnA@row), "Yellow"))) Thank you :)
-
Using IF, AND, and ISDATE together question
So I'm trying to get the answers of "Late" or "On Time" based on if column [Late] says "Yes" in it, and the Column [Actual Date] is a date (any date will do, just as long as its a date). My formula below is just always giving me the response "On Time" regardless if either criteria I'm trying to check is correct.…
-
Enhancement request -dynamic dropdowns in forms
Haven't seen this topic brought up in a minute, so thought I would bring it back up. Dynamic dropdowns in forms would be huge for us.
-
IF, AND, ISBLANK
Hi, If cell A1 = "yes", AND if cell A2 is any value, return "Complete", otherwise return "Incomplete" Help with that formula? Thanks!
-
Countif formula with dynamic range
I'm trying to get a countifs formula to work where I specify a dynamic range. I have a column in my sheet with each row populated the name of one of a handful of assignees - I would like to specify a countifs range to be any row where the assignee column matches a specific name. I would then set the formula to count every…
-
Tracking form back to workflow
I am receiving an update request form that is coming from an old sheet, but I can't find the workflow that is creating it. Is there a way to track the form back to the sheet/workflow that is creating it? Or is there a way to list all my active workflows somewhere? I think I own the sheet that is running this, but not sure.
-
Nested IF isn't working
Hi, I'm trying show offers declined for a certain region by month with the following formula: =IF(COUNTIFS({TA_Offer Decline data Range 3}, $Region@row, {TA_Offer Decline data Range 1}, "Product Management", {TA_Offer Decline data Range 1}, "Engineering", {TA_Offer Decline data Range 1}, "IT", {TA_Offer Decline data Range…
-
Return Date (in text column) from a range based on 2 criteria (is not blank, and match by task name)
Hello, I need assistance with following formula. I have a sheet that tracks tasks by type of job. Each type of job is the parent, with children tasks underneath. Each type of job has a few standard tasks that are the same across all job types. What I am looking to achieve is a formula that will return the Due (or Complete,…