-
Automatically copy cells from one sheet to another
Trying to use VLookup to automatically copy cell data from one sheet to another. I tried to create a function that searches for "Project Name" and "Comments" columns in a sheet titled "Projects" and copies "Comments" to a sheet titled "Campaigns", where the Project Names are exactly the same in both sheets. Can't quite…
-
IF cell is Blank
Hi I have formula here: IFERROR(INDEX(JOIN(COLLECT({Truck Dispatches (Ongoing Jobs)_Status}; {Truck Dispatches (Ongoing Jobs)_Truck}; [Truck reg. number]@row); UNICHAR(10)); 1) This formula looks at the sheet {Truck Dispatches (Ongoing Jobs)_Status} and returns the Status, by comparing the Truck reg. number from two…
-
Looking to track cleanings
Currently I'm looking to add a validation mechanism to a sheet and would like to have a systems that reports after (X number of) cleanings have been completed for the day. This would add a row displaying the room that was complete for the day. If the room was not complete it would show up in red as not complete. I'd also…
-
Is there an automation to move an attachment to a new sheet?
I have a sheet that contains attachments tied to client rows. I'm looking for a way to archive the attachments to a new sheet without needing to go into each row and do this manually. Does anyone know if there is an automation that will move attachments? Thank you!
-
Using the holiday parameter in workday function
=IF(Runs@row = "Daily", WORKDAY([Completed Date]@row, 1, {Holidays Range 1}), IF(Runs@row = "weekly", WORKDAY([Completed Date]@row - (WEEKDAY([Completed Date]@row) - 2), 5, {Holidays Range 1}), IF(Runs@row = "Monthly", WORKDAY(DATE(YEAR([Completed Date]@row), MONTH([Completed Date]@row) + 1, 1) - 1, 1, {Holidays Range…
-
Date formula
Hello! I currently have 2 columns on my sheet, one where I enter date processed and date expired which has a formula to calculate 1 year expiration from date processed. I have been asked that no matter what date I process, it needs to expire the last date of that month. So for example, date processed = 9/5/23 date expired…
-
Combine 2 formulas with an or function
Hi all, I have 2 working formulas that I want to merge with an or function. Either formula 1 or formula 2. Formula 1 has Green as result if first 9 chexboxes are checked,gives red if no box is checked, has yellow if some boxes are checked. Formula 2 gives blue as the result if all boxes have been checked and has yellow if…
-
Combining If and AND statements
I cannot seem to get this formula to work no matter how I set it. I am trying to combine three columns to get an outcome. If CK Type is Hypertension AND Ed language is English, AND Cuff size is Large, then the outcome would be "Hypertension English Large" There are 4 possible outcomes. All data in the screenshot is made…
-
Formatting columns imported from Excel
I made a Smartsheet off of an Excel document. Several columns are marked X in a text format to indicate YES to a question. I'd like to use a checkbox instead. I created a column that has checkboxes next to the first of these types of columns. How can I create a formula that is if column A has "X", then check the box in…
-
Convert to Column Formula Error
I'm trying to make the below formula a column formula. If I copy and paste the formula into cells, it works as expected. =IF(OR([Status]1 = "Complete", [Status]1 = ""), "", "Yes") Two issues, though: 1) The [Status]1 brackets are being automatically removed and reformatted as Status1 2) When I try to convert to a column…