-
Calculating a Duplicate if meeting 2 separate criteria
Hi, I'm currently calculating if something is a duplicate by using the following formula: =IF(AND([PASS NUMBER]@row <> "", COUNTIFS([PASS NUMBER]:[PASS NUMBER], [PASS NUMBER]@row) > 1), "Duplicate", "Not a Duplicate") However, I now intend to expand the use of this sheet, so would like to include another column to specify…
-
Concatenating Contacts List Columns but Omitting One Option
I have two contact list columns that I need to combine into one column. One of the columns however has "Not Applicable" as an option. How do I concatenate both columns but not include any instances of "Not Applicable". Contact Columns are Program Lead and Internal Speaker (this is the column which contains "Not Applicable"…
-
Index Function Has Stopped Working
Has anyone else experienced this as of 2/19/24? In Control Center, many of my sheets that use Index have suddenly had the formula fail to work. These are sheets where they were previously working with no problem. Troubleshooting eliminated the idea the problem was with Match (correctly returns the row index), but even when…
-
Dashboard
Hi, How can I stop a dashboard from refreshing itself? I have the auto refresh turned off in the "view" section, yet when changes occur in the sheets that are feeding to the dashboard, it updates itself. thanks Dorota
-
Does Smartsheet integrate well with any barcode generators?
I'm heading the inventory control department at our lab and we'll need to be able to track parent and child samples throughout the lab via scanning them at which ever work station they happen to be at. Any recommendations for a good barcode generator that works well within Smartsheets would be appreciated!
-
Request help using INDEX MATCH
I'm trying to identify conflicting dates and locations for assets. The assets are entered into the sheet as new rows from a form. There are two columns: [Scheduled Arrival Date] and [Arrival Wet Slip]. I'm trying to use INDEX MATCH to identify when an asset's [Scheduled Arrival Date] and [Arrival Wet Slip] conflict with…
-
Document Creation
Hi All I am figuring out how to do the doc creation in smart sheet - have managed to create a document from my sheet - BUT in the fillable PDF it is not fitting the text into the space created - instead is inserting it as one line and there we cant read the rest of the text - the boxes have enough space to add a number of…
-
can you build a formula to separate longitude and latitude after it was hyperlinked
So I have a sheet where the GPS coordinates are hyperlinked into a column with the use of a form. I would also like to have the longitude and latitude separated into their own columns for exporting to excel reasons. Is there a way to build a formula to separate the longitude and latitude that is being uploaded as a…
-
"Last 7 days" filter is different than >TODAY (-7)
Hello, I need a sanity check: Following a crazy chase for a discrepancy in my sheet, I found out that if I create a filter "In the last 7 days", it starts counting yesterday as day 1. But if I calculate SUMIF is the option {Date} > TODAY (-7), it counts today as day 1. So, my final SUMIF tally is off compared to adding the…
-
Metric Sheet Countifs formula is not quite right - what am I doing wrong?
These first two formulas work in this Metric Sheet. =COUNTIF({Level-ones}, $[Primary Column]@row) =COUNTIF({Status}, [Column5]$23) As seen by the returned values 66 and 21. When trying to combine as COUNTIFS, it gives unparseable reply for the following formula. =COUNTIFS({Level-ones}, $[Primary Column]@row1, {Status},…