-
Date Ranges with Multiple Conditions?
Hello, I am trying to calculate time windows by referring to previously entered dates, but am unsure how to build a formula that takes into account multiple conditions. For the highlighted cell, there are 2 conditions that I am trying to incorporate. For the first condition of "4 to 7 days after V3", I have the earliest…
-
Lost with vlookup or matching?
I am needing to update a Smartsheet to reflect the date listed in a cell from another Smartsheet. Both sheets have an IP address that can be match on as there are no duplicates. The feeder sheet with the date has 210 entries and master sheet has 2800 entries. I want to copy the date field from the feeder sheet to the group…
-
How to create this COUNTIFS with AND/OR/NOT
I cannot figure out how to create this formula to get the metrics. I can get each individual dept metric correct using =IFERROR(COUNTIFS({(Phoenix) Project Tracker - Aerial Status}, AND(@cell <> "No", @cell <> "Complete"), {(Phoenix) Project Tracker - Status column}, AND(@cell = "Complete"), {(Phoenix) Project Tracker -…
-
How to keep a cell blank if there is no data?
I have two sheets a master (2800 records) and a feeder (270 records). I am using the following formula to update a column called scheduled date on the master: =INDEX({feeder06262021 Range 1}, MATCH(IP@row, {feeder06262021 Range 2}, 0)) Which works bringing the date in, however the majority of the cells on the master sheet…
-
#INVALID OPERATION Error
Question: Is it possible to write a SUMIFS column formula to add up specific cells in an adjacent column where the criteria are also in other adjacent columns? (Actually, I know it's possible, because the formula I wrote a couple days ago worked just fine at first, but it's refusing to work today, and I don't know why. The…
-
Search on a text string to return all values
Hello My Fellow Smartsheet Gurus, Is it possible to run a formula based on the text inputted in the column next to it to pull all possible values? I am trying to accommodate multiple ways of finding medication names where an exact match is not always possible? If so how would accomplish this? Thanks so much in advance!…
-
Countifs OR Formula Issues
I am doing a countifs formula, and am unsure how to include an OR formula. In the Summary Program column located on another sheet, I want it to count the number of both Bi-Annual and EMEA cells. for rows which Summary Season is S21 This is the formula I have used that resulted in an Invalid Operation error.…
-
Formulas for % Allocation in Resource Manager
Is it possible to use a formula to generate a percentage in a % Allocation column for use in the Project Resource Manager? Or does a percentage have to be manually entered into the % Allocation column? I've done quite a bit of research on it and haven't found a straight answer yet, but it seems as though having a formula…
-
Why are Round function irregularly displayed in dashboard
When I use a Metric widget in a dashboard, add data (Rounded) from a Grid is sometimes displays the rounded numbers, but the next, without modifications, it doesn´t.
-
Collecting Dates in a Reoccurring Approval
I have a sheet that needs to be reviewed and approved by multiple individuals on a regular reoccurring basis. I have already set up the workflow for this to happen but I will need to keep a list of the dates they were previously approved. Is there a way to use a formula like Join/Collect to do this? When I try it will just…