-
Need a formula to count a multi-select dropdown cell if its contents include "has any of"
Hi there. New to Smartsheet so forgive me if this is basic. I have searched the forum but can't find the specific usage scenario. I am trying to create a Sheet Summary formula to count all the cells in a certain row [Tags] that contain a specific "tag" eg. "Mid-M". Seems easy enough but because its a multi-select dropdown…
-
Formula to count the how many times "Monday" is listed
This is for a ticketing system. I want to count the number of requests that come in on each day of the week. I am looking for a rolling YTD number. I have a metrics sheet that pulls the data from a closed tickets sheet. This is the formula I tried using: =COUNTIFS({Resolved Date Range}, CONTAINS("Monday", @cell)) Any help…
-
Calculating due dates
Hi there I am trying to calculate a due date from a "created date" column and a number column,. So want it to calculate the due date given the number in the "target turnaround days column" eg 3, but exclude working days. Can anyone help please, Melissa
-
How to pull in MAX Date based for "Charter Approved" and "Project Baselined" when they are 100%?
Hey folks, I'm looking to pull in the MAX Date for when: • Charter Approved is Dated and 100% Complete • Project Baselined is Dated and 100% Complete For the screenshot below, the date pulled in should be 10/05/2021 I'm not sure if it matters but the formula is going into a Text cell. Thank you!
-
Using Countif with IF statement
In my sheet I have a range I am counting which works fine. For example: =countifs([range name},System@row) Now I want to reference another range name the location which meets the entry in the row I can't see to get the order of syntax correct.
-
Is the only way to create a dynamic view from multiple sheets to use a report?
I am looking to create a dynamic view configuration that pulls the information from multiple sheets. I know that you can create a dynamic view of a report, so is this the only way to create a dynamic view of multiple sheets?
-
IF and IF/AND formula - Please help! thanks
Hello, My current formula that I have is =IF(Status@row = "Complete", "Green", IF(Status@row = "On Target", "Green", IF(Status@row = "In Jeopardy", "Yellow", IF(Status@row = "On-Hold", "Yellow", IF(Status@row = "Past Due", "Red", IF(Status@row = "Archived", "Green", IF(Status@row = "Complete Past Due", "Green",…
-
Multiple IF function
Hi All I am battling with a formula for the following. If the Ticket status column, is "New" or "In Progress" and the Days Past Due date is less than 0, return "OVERDUE", or else "On Track". Can any one help please, I am new at the formula thing.. Regards Melissa
-
Automate Direction Symbols
I've got a calculated cell. As that cell changes, I'd like to automate the direction symbols to match the direction of change. i.e. If the value goes from .61 to .63, the "Up" arrow would show. Possible? Help?
-
Requesting additional actions after approval is granted. (Need to select a charge account)
Employees will select a shop they work for when requesting on the form. The shop determines which manager needs to alerted to approve/decline the request. If the request is approved, I need the manager to ALSO submit a charge account for the request to be charged to. Trying to get this done in one email, which is to…