-
Reporting - Using Two Sheets, Getting Duplicate Rows
Hi All - I've created a report which uses two sheets. The goal of the report is to leverage columns from both sheets as they both have data I want to report on. Sheet 1 actually copies to Sheet 2, so all the formatting and column names are the same, but there are additional columns in Sheet 2 for other reasons. When I…
-
Hiding Or Removing Duplicates In a Report
Hi all! I have a report on a sheet that has many duplicate values, and for the sake of nice presentation I would like them hidden. To further explain my situation, I have a sheet I am referencing that has tasks, days to complete, the week of completion of these tasks, and finally the avg days to complete a task per week.…
-
Smartsheet Modified at cell capturing on Log in issue
We are trying to build an end of day report that shows the updates that were made to open tickets throughout the current day. However, for some reason every day when my user logs in, the sheet seems to capture changes to every cell marked "Open" in the sheet, and the modified date to all the open rows in the sheet gets…
-
Reference a table like in Excel
I am working on a per diem sheet that will automate the calculation of distance between the employees address and the jobsite. I have an excel sheet that our payroll has been using that I am trying to replicate some of the formulas to keep things the same. I have run into a formula that references a group of cells for a…
-
Convert drop down in text format to date format
I have seen various other questions in the community, but I can't quite get my equation there, I am trying to convert a drop down from a form to a date in the adjacent column. All dropdown items are formatted as follows: 7/07/20 Here is what I am trying: =DATE(VALUE("20" + RIGHT([Testing Date]@row, 6, 7)),…
-
Formula won't recognize cell data
Hi, I have several formulas in sheet summary that reference a single person in an assignment column in my sheet. The formulas are repeated multiple times and work just fine, however I seem to have issues with this single person. Any formula that includes this person, does not work. Any insight on how to fix this? I've…
-
I am trying to find the right formula referencing dates and an identifier column
I am working on a formula to check all boxes in the rows that match the identifier column if there is a projected date and it is greater than or equal to today. I collect the start and end date and if a class is delayed or ahead of schedule it collects the projected end date. What I want is if the class is still going on…
-
IF And formula with cross sheet reference gives invalid operation error
Hi team, This is probably so obvious but i don't manage to get the following formula to work: =IF(AND({EMEA KPI General data Country} = Country@row, {EMEA KPI General data Payroll month} = Month@row), {EMEA KPI General data Reason for manual pay}) I get error invalid operation. Can you help? Thanks Judith
-
How do I add an additional piece of criteria to this formula
This is the current formula =COUNTIF({CAR Range 1}, AND(@cell >= DATE(2022, 1, 1), @cell <= DATE(2022, 1, 31))) I want it only to count the cells with this date range AND that have the word Toyota. How would I modify the current formula?
-
IF/AND formula for RYGG balls (for status and due date)
Hi, I've combed through the community site posts but have been unable to solve the issue with my formula. I need the parameters below with #4 taking priority over #3. They "Cancelled", "On hold", "Complete" and "In Progress" are working but adding in the "Due" does not work. Any help is greatly, greatly appreciated!!! The…