-
Can I write a formula to check a box once a period of time has passed and a cell is blank?
I am working with 3 columns; "Proposal Submission Date", "Project Awarded", and a checkbox indicating "No Response from GC." Can I write a formula which will check a box after looking at my submission date first to determine if it is 6 months old or older, then looking at the "Project Awarded" column and determine if there…
-
Cross Sheet Reference a URL Link
I've got a database sheet listing a bunch of fertilizers and how much to feed of each fertilizer at various stages of growth. During certain stages of growth some fertilizers aren't used so I'm using this sheet to feed reports which builds an easy to read list of what to feed so that any fertilizers not used aren't shown…
-
Rag Status for end date and % complete
Hi there, Could somebody help me with this formula for a rag status please? The one I'm using at the minute is not picking up red statuses. =IFERROR(IF([Percentage Complete]@row = 1, "Blue", IF(AND([Percentage Complete]@row < 1, [Finish Date]@row > TODAY()), "Green", IF(AND([Finish Date]@row < TODAY(1), [Finish Date]@row <…
-
Can you combine if and or formulas
Here is the formula that I currently have and works great currently: =IF(COUNTIFS({UCA App E#}, [E #]@row, {EPU approved}, true) > 0, true, false) First is the match the text in "UCA app e#" and "E #", but also needs "EPU approved" which is a checkbox, to be 'checked'. I need to add a second field that is a check box to…
-
INDEX-COLLECT Formula Returning #INCORRECT ARGUMENT
Hi Smartsheet Community, I've already perused a number of Community postings related to this formula, but I can't seem to work it out. On my source sheet, I have the following columns: 1) KES Number 2) Date 3) Time Spent On my target sheet, I have these same columns in addition to other data. So far, this is the formula…
-
Two forms, one sheet moving responses to new cells
I have one sheet with two forms. It's for employee onboarding. One form records some information from the employee and one form records information from the hiring manager. Two new rows are created in the sheet once the forms are complete. I'm trying to link those form responses to other cells within the same sheet (in a…
-
How can I create an inventory checkout form that shows availability of equipment using barcodes?
Hi Smartsheet Gurus! I want to create a library style system where staff can request equipment through a form and know instantly if the item is available. I think this can be done using the barcode inventory management template, but I don't know how to link the barcodes to the forms. Any tips/formulas/guidance from the…
-
Health Column taking Predecessors Column into consideration to determine color.
I have the following formula in the health column. =IF(OR(Status@row = "Completed", [End Date]@row - TODAY() >= 7), "Green", IF([End Date]@row - TODAY() <= -1, "Red", "Yellow")) It works fine. If End date is more than 7 days out then the health column is green, If End Date has passed then Red. The problem is that I didn't…
-
"Locking" an Index/Match formula
Hi, I am using an index/match column formula to look up an approver from another sheet. This is working fine, but I am going to need to change an approver and want to keep the previous approver listed for the past records. Does anyone have any suggestions on how to do this? I would rather not create a new column or copy…
-
Trying to checkmark an entire column based on an absolute cell reference. Help pretty please.
Hey there, So, I'm trying to automate a process where if a new row comes in (through a form) with a checkbox "checked" (in column Open ECO? row 1 only) that the check marks in Column 18 will all be checked. Any thoughts? thanks in advance, -ryan
