-
Formula to display one date in a range with 3 criteria
Hello everyone, Can you please help me with a formula? I have three columns: 'Start date' , 'Dose', 'Site'. I would like to consider multiple criteria: 1) the start date is in the future 2) the value in the 'Dose' column is 'drug' and 3) the Site is '01'. Based on these criteria there should be a list of dates, but I would…
-
How do I customize a request ID based on specific form selections?
iaI know how to create a request ID on the column grid but I wonder if I am able to customize based off of specific selections on form submissions. For example, Jane Doe selected content management (CM) in her form submission so the request ID would reflect that (Request ID: CM_0001), where John Smith selected quality…
-
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)))…
-
Allow automation to populate cells with formulas.
For some reason the devs have blocked using =formula() and they populate cells with '=formula() when you try to use the features in conjunction. This makes your formulas inert and is quite frustrating. This seems like such a easy way to increase efficiency in the program and should be implemented immediately. Thanks for…
-
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…