-
How can I capture the value in a parent row to match the value in one child row?
I have a matrix by job title that each child row enters one value. So there are 4 child rows, but only one value in each of the 4 columns. I want the parent row to reflect the value when not blank of the child row beneath it. Is that used with a MATCH formula? How can it reflect "if not blank" and take that value, whatever…
-
Combining Average and Rounding up to x.x
Hi I need some assistance on a formula that will take the average of multiple numeric columns and then round to the nearest 1.0 [first decimal]. For instance, 1,1,3 average up to 1.666667 - I would rather just have this round up to 1.7.
-
If today is less than end of month dont calculate
Hello, I have a formula I am working on to identify if a report was received on time, late, or not at all, however, I do not want it to calculate if todays date is less than the last day of that month. For example, for November, since today is 11.22.22, it would return blank since today is less than 11.30.22. However, it…
-
How do I pull in two contacts into a specific cell?
I am trying to write a formula to pull in a contact based on identifying role into an assigned to cell. So where it says Regional Admin and Manager, I want to pull in both of those contacts based on what gets entered into the Assigned To cell. I managed if it was a single contact by using =[Assigned To]@row I had to drag…
-
Copy Rows automation isn't working how I want
Hello, I am new to Smartsheet and so far I am loving it. However, as with learning anything new, I am running into some blocks that I need guidance with. I created a portal where a "claim" can be submitted. I have the sheet setup to pull in up to 15 items. However, the claims dept wants a sheet that cascades the items per…
-
How do I add a contact to a report that’s pulling select tasks from multiple project schedules?
Newer user here!! What’s the best method to pull a contact (PM Assigned To) from an intake sheet into a report that’s already pulling select tasks (Materials) from multiple project schedules? I'd like to be able to show the project manager, as well as sort by PM, for the project on a materials report; which is a list of…
-
Help with formula to check box based on specific criterion
Hi team - need your help. I have a formula that computes the actual day between 2 dates (using NETWORKDAY) which returns a number in that column cell (days count). I have a "helper" check box column next to that column cell that I need checked if the actual days is equal to or less than 10 days AND not 0 (or blank). I've…
-
How to use Countifs for rows that start with a certain character?
I am trying to use countifs formula. I want it to return how many there are that meet two criteria- the first being the first digit of a three digit number in one column is 1--. It would also have to be "Completed" in another column. =COUNTIFS({Number}, HAS(LEFT(@cell, 1)= "1:"), {Status}, "Completed")
-
Why do i have issues with moving a line from one sheet to another?
I am trying to move a line item to a different sheet as an archive, but it says that there is an issue with Smartsheet. I can move lines for other sheets but not from my "Master List". My automations run but it says that not all actions can be completed. The automation is just a move based on a flag. I cannot manually move…
-
Trying to count the same status from two sheets - Getting unparssable error
=COUNTIFS([Engagement Phase]:[Engagement Phase],CONTAINS ("DIAGNOSTIC (CALL SETUP)”,@cell), {DoD Status}, CONTAINS ("DIAGNOSTIC (CALL SETUP)”,@cell))
