-
COUNTIFS Column A is blank and Column B does not contain 1
Hi All, I am struggling to make the COUNTIFS formula work in a Sheet Summary Field where Column A is blank and Column B does not contain 1. NOTE: Column B is a formula column with the following - =COUNT(ANCESTORS([Risk Number]@row)). =COUNTIFS([Column A]:[Column A], "", [Column B]:[Column B], NOT(CONTAINS("1", @cell)))…
-
Formula regarding parent / child rows
Hello, I'm trying to create a formula to automatically populate a column based on if the row's primary column cell is a "parent" or "child." The column I want to automate is titled "Level." If the primary column cell at that row is a "parent", I want the "Level" column cell at that row to automatically populate "1." If…
-
Tracking Contact Approvals in Hierarchy Level using Helper Column
Hello Smartsheet Community, I'm creating a Smartsheet Automation to send out approvals (starting with level 1). I'm making this helper column (L1 - Status of Approvals) to determine if all the listed contacts have given approval in the contact approval columns before moving onto level 2. As you can see in the screenshot…
-
Error Message "Some cross-sheet formula can’t be updated"
Dear Smart Team, I am getting below error message again which cause not triggering workflow automatically. "Some cross-sheet formula can’t be updated, because this sheet has more cell referenced from other sheets than the maximum allowed (100000)" How can I get the permanent solution to avoid this error. Refer attached…
-
If & Workday Formula
What is wrong with my formula? I want to calculate 3 workdays from the survey request date but only if the site plan test fit is checked…
-
Merged: Able to use summary field from other sheet as a reference
This discussion has been merged.
-
Countifs Past 90ds referencing another sheet
Hi, I am trying to make a dashboard that shows the top 10 pieces of equipment with the highest number of issues in the past 90d. I have my primary sheet that collects the data (Primary), and a reference sheet I am using to collect a count. I am just struggling to have it filter the last 90d. Showing #invalidoperation…
-
WEEKNUMBER formula: fix issue when 31th december is in mid week
Good afternoon from Spain. I faced an issue with WEEKNUMBER formula. 30th december is monday, 31th december is tuesday. If we calculate their weeknumber, the answer is '1'. This behavior is incorrect. 30th and 31th december should be = 53 (week number). I wanna ask to fix this. When one of the last days of december are is…
-
COUNT MATCHING VALUES FROM TWO DIFFERENT COLUMNS ON A SEPERATE SHEET
Hello, What I first thought would be an easy formula has turned out to be quite a pain. I am trying to count the number of rows where one column matches the other. My formula returns #INVALID OPERATION. =COUNTIFS({Agent}, @cell = Name@row, {Offer Amount}, {Secured Amount}) The thing that confuses me is, even when i go to…
-
Help with TIME() Formula
Hello, I am testing out the TIME() function and working on a formula to determine the amount of hours and minutes elapsed between a Start and Finish columns. I thought I had it figured out, however, I noticed that for my row that has a Start time of 3 pm and a Finish time of 5 pm, it was showing a time difference of "1…