-
Multi Page Formula dragging:
I am working with multiple data sheets where my formula draws information from the same cell in 4 sheets, i.e. =SUM({pg1 cell1}, {pg2 cell1}). The formula works correctly, but when I try to tag and drag or C/P the formula into the rest of the cells in the column, it simple duplicates the same original cells, rather than…
-
COUNTIF Date is the same in 2 different columns
Hi, I would like to COUNTIF the date in "Start date" and "End date" columns, on the same sheet, are the same. It was quite simple to do it in an extra column per row: =COUNTIF([End date]1, [Start date]1) But would need to expand every time a row is added. Unfortunately, even after looking on the forum I didn't succeed to…
-
RAG Formula Used with Duration (Project Settings)
Smartsheet Community: I have a Formula (Below) that I am using for RAG but the Results come back Blank. Does anyone know if it is because the Duration is part of the Project Setting that is Hard Coded in Smartsheet? Formula:=IF(Duration@row = [Total Capacity (Hours)]@row, "Yellow") and Screen Shots
-
Is there a way to write a formula that will raise a flag to if row data for household size AND ...
I am trying to write a formula that will raise a flag if the row data fits specific criteria for determining income eligibility for a project. Basically it would be if the data on that row in the household size equals a number and if the annual gross income is less than or equal to a dollar amount, we need it to raise the…
-
Approach to count new rows by day for reporting
We are using smartsheet to track issues from UAT and I want to be able to report on the number of issues added each day, and closed each so I can create a bar chart for the dashboard. I was able to calculate the number of new each day with this formula using the system created date column. I have a field for status and I…
-
Identifying trends with =countif?
I have a drop down list of about five hundred items that my four vendors can select from. I'm trying to track trends of frequent selections, such as the top five things + how many times it's been selected within 30 days + who has selected what. I've used =COUNTIFS(Item:Item, "item name", Date:Date, >=TODAY(-30)) in the…
-
SUMIFS Children Rows when Date is Filled Out
Great Morning! I am trying to do a formula so sum children rows with SUMIFS following this criteria =SUMIFS(CHILDREN([TOTAL OWE - LIVE]:[TOTAL OWE - LIVE]), CHILDREN([MUNIS APPROVAL LEVEL 5 DATE]:[MUNIS APPROVAL LEVEL 5 DATE]), ISDATE(@cell)) In other words, on the parent row named TOTAL PO LIQUIDATED I would like to get…
-
Automatic Update Request
Hi everyone, I want to set up a daily update request so my TODAY function can be refreshed everyday automatically without me having to refresh the page. My challenge is, I don't know what my trigger should be. Currently, we have an online form and this form is not used everyday, it could be days or even weeks in between a…
-
Auto Propagating Formulas
I have two matching sheets one that captures baseline dates, the other with current projections for many (~100 milestones). I would like to generate a third sheet that has the metrics of #days difference between the baseline and current dates. I can do this using "netdays" and adding references from the two other sheets.…
-
Contact list format
I'm trying to use the text contact list for something, but when I ask it to convert the contact list cell to text and put it in the next cell so I can use it, it is very random in how it "translates" the list - some have quotes and some don't. After some thinking, it appears that if the names have a comma in them (i.e.…
