- Report not displaying rows
Can anyone assist? I have two reports with the same set up but for some reason my second sheet does not display the corresponding rows under grouping. In the first sheet it works fine: However in my second row, It's asking me to filter but does not show the rows even if I filter by date. Any idea on why? This sheet has…
- Multiple Check Boxes - Pre-Fix, joining values based on multiple check boxes.
What would be the best formula to join "text" from multiple check boxes if values are true or false? I would like to populate, the in the grey column, the values of each check box if any are true with a "text value" of the name of the check box column. I have several grey columns that will be used in with join/collect on…
- Index/Match using two criterias
I'm trying to see if I can use index/match with two criteria's. First criteria being the name, and the second the month. So far I am using this: What would be the best way to match Operator Name & Month? I am referencing another sheet that has Name & Month as well, followed by the summary. This seems to be the formula!…
- Barcode option not available on form.
There is no barcode scanner option when using the shared form link on mobile. Is there a work around for this that does not require actually having the app installed?
- Removing Partial Text From Prefilled Column
Hello! I'm currently using the following formula to extract just the time =SUBSTITUTE([Completed Timestamp]@row, DATEONLY([Completed Timestamp]@row), "" When used with automation/move by a check box being true, it populates correctly. However when using automation/move when rows are added and matching a "Category" column…
- Using RIGHT/LEFT or FIND/REPLACE?
I thought that by using RIGHT and returning the values after ", " that it would fix the issue I'm having but depending on the difference in timestamps, I may get 7 or 8 characters so this formula doesn't work out for me. Would using FIND/REPLACE work, such as finding ", " within the column and replacing that with just ""…
- Changing Value Prefilled Cell Only if Matching Value
The following rows are moved by automation to this sheet with without the formulas just to display the values. What is the best way to have any cell under "Duration" column that if it matches "#INVALID VALUE" to Display "No Downtime/Delayed" without clearing the rest of the column?
- Multiple Check Boxes - Adding Pre-Fix based on checked boxes and join/collect on multiple rows
What is the best way to add a prefix based on the check box being true or not? I have a tracker that I use to refer from to my main roster. I would like to populate in the notes "Late", "Absent", or "Early Dismissal" if that column is checked, followed by the following: Late - 03/29/22 - "Detailed Content" Absent -…
- How to combine cell data from reference sheet.
I would like to combine all notes into my Roster sheet from my reference sheet that has multiple notes. Please assist with my formula.
- IOS SmartSheet APP , Search tool within PDF
Is there a work around to access the search tool for PDF attachments on tablets? I noticed that there was no option to search an attached PDF file for a specific text/number.
