-
Multiple IF and IF (AND) arguments in one formula
Does anyone see any obvious issues with this string? I'm trying to pull from two columns [VA Feed status], [QA Feed status] and output one status based on the column statuses. This is a combination of IF(AND) and also just IF statements. I'm currently receiving #UNPARSEABLE =IF(AND([VO Feed status]@row = "VO: Pending file…
-
Indicating a row is past due
Hello everyone, I was wondering about a capability in Smartsheet. I was hoping to indicate a row was not completed on time. I am not talking about conditional formatting per say. I do not have a preference how this is shown but I was thinking of a function where a cell column of that row is in red? This Smartsheet is used…
-
How to Alter the "Sheet - IT Ticket Metrics"
I want to alter this sheet, found in the IT ticket Template, to just show the metrics for a specific customer. the original formula looks like this: =COUNTIF({Created Date Range}, IFERROR(YEAR(@cell), 0) = YEAR(TODAY()) - 1) and my attempt to specify to a single customer looks like this =COUNTIFS({Created Date Range},…
-
Formula or conditional formatting for highlighting unique task names
Hello Smartsheet Community, I wanted to "copy" condition made in excel into my Smartsheet, and can't get it done right. I would need to highlight unique title for the task, which doesn't exist in a different raw. I tried some different condition option but it only highlight either blank rows or every one. No idea if this…
-
Collect record for previous day to Calculate variance
Main problem: I am attempting to collect the record of Daily absent for the previous day, I get incorrect argument error. I could use any help. My end goal is to use the previous day record against the daily absent record to get the variance in numbers and percentage. I would appreciate any other intuitive way of doing…
-
Mid Date between 2 dates
Hello, Can anyone help me with a formula to find the mid date between 2 dates. Like what will be the mid date between 1st Jan 2021 and 31st March 2021.
-
Is there a way to count the number of CHILDREN in a column?
Hello, I am trying to count the number of CHILDREN I have on a single sheet in my Primary column in order to output the total number of projects we have. My hierarchy in my in my Primary column is "Project Manager" (PARENT) and then "Project Name" (CHILD). I want to count the total number of CHILDREN in that column, but…
-
How to create an Index Match Formula for multiple sheets?
Hi, I am currently trying to create an Index Match function which will be able to search multiple sheets (5 to 6 separate sheets) for the correct information. The destination sheet has two columns that it will look at. A "TIDC" column where staff members place a ticket code An "Assigned to" column, which is a contact list…
-
Out of Service Formula
Hi Community, I'm attempting to create a formula showing the OOS status of the most recent submission for each asset based on the Asset ID in form submissions. For example, below Asset ID FD-001201 would be considered out of service, however, I'm not sure how to account for it being the most recent submission if there had…
-
Index Match Across Multiple Sheets
Hi Everyone, Hoping y'all can help as I'm at a complete loss. I'm trying to pull information into 1 master sheet based on a unique identifier across multiple sheets and it's just not working. I can get it to work for 1 sheet using =INDEX({Status},MATCH([Proj ID]@Row,{Proj ID},0)). Each sheet is for a different team,…