-
Comparing Data Across Multiple Columns on the Same Sheet
Hello Smartsheet Community! We have (4) columns of data that we need to compare against one other (2 sets of 2 columns) One set of (2) columns represents what was ordered, the other set of (2) columns represents what was received. The ID numbers in these columns could be in either column, based on how the data was entered…
-
Formula and automatic hyperlink cell back to other sheet
In a sheet, we have a column formula taking a value from another sheet using 'reference another sheet' we would like it to create a hyperlink back to the other sheet where it took the value from. How this is helpful: we have a vendor portal where our vendors send in their invoices via a form to a sheet, then in one of the…
-
Filter to show recent and active meeting items
Hello all, For my project meetings i have a combined agenda for notes and actions using a standard form. I am trying to apply a filter to keep things more recent when we review it. Excluding parent rows and workstream headers, i really only have two types of row - note or action. In both instances, they have an assigned…
-
Seeking formula to catch mismatched dates for a single project across multiple Smartsheets
Hi, Smartsheet community. I am hoping someone can provide guidance on a path to solve this problem. Since our team doesn't always get alerted when a project is rescheduled, we are looking to compare dates between our main Smartsheet and the information we extract from our company's master scheduling platform and…
-
Best Way to Pull A Ton of Data
Hello Community, I have recently been given the challenge of pulling a ton of data from a source sheet to a target sheet, and am trying to figure out the best way to pull all the data efficiently and not run out of space too quick. Unfortunately we cannot use data mesh because each row has 7 target columns to pull from.…
-
Formula no longer working in Sheet Summary
I have a sheet with sheet summaries that were working for the last month and I recently updated with data shuttle and its no longer working. I keep getting the sum of 0 even though it was working before. =SUMIFS([Quantity (G)]:[Quantity (G)], Material:Material, CONTAINS("200002", @cell), [Pick-up Date]:[Pick-up Date],…
-
If Formula not reading blank correctly
Hi, Any chance you can help me figure out why my formula is not working and assist in fixing it. The formula right below is the one I am trying to get to work and I am wondering if there is a way for the Purple box that says complete to say "not started" since it clearly has not been started. =IF(COUNTIF(Status78:Status82,…
-
IF AND Formula to auto populate a checkbox
Hello, I am creating a report that references another sheet. I would like to know if a person from a certain organization attended a training. The formula looks at 2 different columns from the other sheet. One of the columns has the name of the organization, the other column indicates if they were in attendance. In my…
-
Change date every week
I have a sheet and I want resources to provide their status update every week. A request to update is sent every Friday. I want the "Current Week Ending" to be the Friday of the current week. Resources can enter their update for that week starting the Wednesday before till the Tuesday after. Every Wednesday, I want the…
-
COUNTIF/S Formula?
Hi All! Needing some help with the below query, the outcome is extremely straightforward but I feel my immaturity with SmartSheet is causing some blockers. Question at hand: I currently require the formula COUNTIF/S to count multiple criteria within a row but I can only seem to get it to work for one. For example I need to…
