-
COUNTIFs across multiple columns from another sheet
Hi all, I'm currently struggling to execute a formula to count the number of times a contact appears across multiple columns from a sheet I'm referencing. I know I can just add two COUNTIFs statements for each column but this doesn't solve my problem of only wanting a contact to be contacted once for each row (eg if the…
-
Online Active Performance Monitor on sheets
I recently ran into a situation where important automated row moves were getting stuck for sometimes hours at a time, instead of moving immediately based on their automations trigger. The structure was: Automated Move Row 2, from the Intermediate Sheet to the Final Landing Sheet, was the one getting stuck. I had…
-
Checking checkbox if the cell on the same row in a different column contains one of several values
Hi all, I'm currently having a little bit of difficulty writing a formula for a checkbox column. I intend to write the formula so that the box will be ticked if at least one of three values (people's names in this context) appear in a different column on the same row. I can get it to check by only specifying it contains…
-
Creating a Booking System with a Time Component
Hi everyone, I have the following asset booking system and received feedback that I should add a time component to it: Unfortunately, I haven't been able to get it to work correctly as, in the above screenshot, you can see that the booker is stating the asset is available when it is not. Additionally, the 'Assignee in…
-
Email content into a sheet
Box has a great feature where you can send an email to a specific box email account, and it will automatically put the attachments into the folder associated with it. It would be great if we could email a designated smartsheet email, and have it automatically add a line to a sheet with the attachment or content included.…
-
If column does not contain string return N/A
Hi, I've created a formula to return me the average "word" that appears when the Title column contains the string "1. Establish Baseline for Web Performance": =IF(AND(COUNTIFS(Rating:Rating, "Extreme-4", Status:Status, "Open", Title:Title, "1. Establish Baseline for Web Performance") >= COUNTIFS(Rating:Rating, "High-3",…
-
Correcting WeekOf and Avg Formulas
Hi all! I am trying to do 2 operations on some columns I have in a sheet. I have written (with your help ofc!) 2 formulas to fit my needs, these are a week of, and a avg formula. To be more specific, I have a sheet that has tasks on it. Assigned to these tasks are days it took to complete them, as well as the day of…
-
Import Excel file and include embedded images
Hi, I was not able to find a way to import an Excel file that has images embedded in cells, and keep those images when the import in complete. Is that possible? Am I missing something? Or do I have to re-import those images manually, one-by-one? Thanks in advance.
-
Auto Assigning Values In Smartsheet
Hi All! I'm back with another project for work. This time I am trying to auto assign values to a column. Essentially we have tasks as rows, and one of the columns in the row is percent completed. I would like for the value of percent completed to auto-fill to 0 Whenever a new task is made, and leave it up to the employee…
-
How to return only the most recent entry before a targeted date range?
Hello, I currently have the following asset booking sheet: What I'm trying to do is, for the column 'Assignee in Possession Before Your Booking Date:', if the asset is available within the booking date range that the user has entered -- I would like the column to display what assignee will have the asset last (most…
