-
Help using the NOT formula
Hello! I'm trying to write a summary formula to count how many projects have a Resourcing score of 8 or higher and the approval status is not "canceled." This is the current formula I'm attempting: =COUNTIF([PM Resourcing Score]:[PM Resourcing Score], >=8, AND(NOT(CONTAINS("Canceled by Specialist Team", [Approval…
-
Meeting Room booking using SS Calendar App
Hi All, I'm in the process of setting up a meeting room booking system where I display date/time availability and different status indicators (confirmed, tentative, waitlist). I'm currently using two sheets: one to collect meeting information via a form and the other to manage meeting slots on the calendar. I've…
-
INDEX MATCH and COLLECT all at once
I have used INDEX({Array},MATCH(Value in Column),MATCH(Value in Row)) to retrieve a value by matching the column and row I have used INDEX(COLLECT(Reference Column, Criteria 1, Criteria 2)) to collect What I am trying to do now is retrieve a value from an array based on the values in two columns and one row I have a sheet…
-
"and" logic for multiple condition in a form
Hello, I created a form for which I would like to display a field if 2 criteria are met BOTH -> currently a "OR" logic is automatically set: Where can I change the "or" to "and"? Thank you
-
Conditional dropdown list from another sheet.
Hello All Is this possible? Is there a way to get conditional dropdowns? Meaning column 1 column 2 dropdown contact trade cat Market Framer Pittsburgh dropdown would pull framer from Pittsburgh All the contacts would on 1 Master sheet. Master sheet would have corresponding Trad cat column and Market column. On the…
-
Conditional Dropdown menus
Hi community, Has anyone come up with a smart workaround for the conditional dropdown menus? Ideally I'd like my sheet to have a dropdown list in Column1, and based upon what is selected in column 1, a specified group of values appear in a dropdown in column 2. This exists as a possibility in excel, but not in smartsheet.…
-
Count if Children Rows are Completed
Hi All, I need a formula that counts how many children tasks don't have a completed date entered yet. See the screenshot below. My formula is: =COUNTIFS(CHILDREN(Task@row), <>"", [Completed Date]:[Completed Date], "") However, it returns an incorrect argument. Any suggestions would be greatly appreciated!
-
Why can't I use automations on RYG ball columns?
Hi, Does anyone know why we can't use automations to change the cell value in symbol columns, like the RYG balls? It doesn't make sense to me that it's available for dropdowns but not for these. I do realize I could use a formula here, but that is not what I am looking for. I am looking for the specific capabilities of the…
-
Tracking Time in Status Levels (New, Review, Hold, Process, Resolved)
I have a maintenance request sheet where user fill out a Smartsheet form and submit their requests. Internally, the request is received as "New" and will be manually changed to various status levels over time (i.e. "New" to "Review" to "Hold" to "Process" back to "Hold" back to "Process" to "Resolved"). My question: how…
-
Formula not working
Hello, I am trying to make a formula that will automate a symbol based on a text in another column. Below is my current formula that isn't working. Any help would be appreciated! Designations I would like are: Complete = Green; Planned = Blue; In Progress = Yellow; ON HOLD or N/A = Red =IF(ISBLANK([RegSci Review…