-
Health Formula
I'm currently trying to create a formula that will allow me to update the health status of tasks using both the due date data and the status of the work. I've tried looking at other discussion forums, but using those formulas does not seem to be working for me as they are causing errors. Is there anyone out there that's…
-
SUMIFS and CONTAINS Formula
I am try to sum the total weight of a column on a different sheet if the name contains certain text and will be released on a certain date. I am using the below formula but getting #INCORRECT =SUMIFS({Estimated Weights Range EST Weight}, CONTAINS("C-Vibez", {Estimated Weights Strain Name}), {Estimated Weights Est Release…
-
How to use any date within a date range as formula criteria?
O, great wizards of the Smartsheet community, hoping you can help me cast a formula spell. Trying to create a formula to flag if a resource is overallocated in a master sheet that tracks resources across multiple projects. NOT using either the legacy resource management or RM by SS, just core Sheet functionality. I managed…
-
Project status synchronization between 2 sheets
I have 2 sheets (2 project trackers) and need to present the status in a "master" tracker based on a data from the "slave" one. The problem is that in the slave there could be couple (even 20) rows that are connected to the one project in the master file. They are connected via Project Name column. I need to somehow merge…
-
Rolling Year Formula
I have a file that will be used to calculate 13 rolling periods for graphs and reports. The file contains 13 rows only for the number of months needed in the reports. I need a formula that will enter the year number in the "RollingYear" column. I have the formulas for the needed month number. The start calculating from the…
-
Formula not doing basic math correctly
im trying to build a metric for a dashboard that finds the percent difference between the actual and the required amount. for some reason going =[Required Capacity]@row / [Actual capacity]@row gives a different answer than =140.5/145.3
-
FILTER function
Is there an equivalent of the FILTER function in Excel? =FILTER (array, include, [if_empty])
-
Removing Duplicates
Hello, I have a sheet that I am going to import data into via Data Shuttle that contains a list of requests that need to be approved by a manager. Once the data is imported, I am going to set up an automation that sends an email notifying the manager they have a pending request. The challenge is one manager's email address…
-
Checking for duplication across two fields
Hi Community Have used the formula posted to this forum to identify duplicates in a single column using [IF(COUNTIF())} formula. I have a site/dept type issue split across two columns and need to identify when the same site/dept combination has been used in another record. I have tried using AND in the COUNTIF() but just…
-
Select Value, not the formula, in a cell.
Hello, I have a cell where I join a column of cells with keywords into a single cell. This combines the keywords from all the entries on the sheet into one cell for use in analysis of all collected keywords. I want to copy the combined keyword list, but I can only seem to select the formula that is generating said list in…