-
IF/AND/BLANK Formula Logic
I'm trying to write a formula to reflect a progress % (using the bar symbol) based on three fields, where one field, if filled in, counts as 25%, the second field, if filled in, counts as 25%, and the third field, if filled in, counts as 50% (to equate to 100%). I'm using =IF(AND(NOT(ISBLANK, but I'm receiving errors. I…
-
Help with AND function
I am trying to have this formula populate a name only if the Component Type is "Teacher Guidance" and the Resource/Object type is blank. I have an incorrect argument set and am not sure how to use AND here or if that is the function I need to use. =IF(AND([Resource/Object Type]@row = 0, [Component Type]@row = "Teacher…
-
Unsure which formula to use (Collect? Join?)
Howdy all, I'm working on a project template that has a RACI already filled in with cross functional positions. i.e. in the C column for task A I might have (product manager, key accounts manager). I then want a formula that references a contact list for the project team so when it gets filled out, the RACI will auto-fill…
-
SUMIFS Formula for Column with Various Possible Returns
Hi there! I am a big Excel user switching to Smartsheet and need help with a SUMIFS formula. In Excel, the formula was: =SUM(SUMIFS('Outside Counsel Invoices'!$G:$G,'Outside Counsel Invoices'!$M:$M,"FY23",'Outside Counsel Invoices'!$D:$D,{"=7607","=7607*"})) Since Wildcards (*) are not used in Smartsheet, I am struggling…
-
Sorting consecutive numbers with text
Hi, This might have a very obvious answer, I have a list of items with unique numbers, I want to sort them but some of the cells will have additional text, e.g. "34563 item 1". I want it to look like this: 34563 34563 Item 1 34563 Item 2 34564 34565 But when I sort the column it doesn't put these 'text' cells underneath…
-
How to write formula for?
When Crew column is either LT_PAP_010/LT_ELK_006 I'd like to have the Coord/ Appt Status column present 🟢 for LT_PAP_010 and ✅ for LT_ELK_006 when Coord/ Appt Date contains a DATE or Order Type column contains READY. Thanks
-
Sign in sheet barcode matching
Hello, We're looking to create a workflow for visitor sign-in where there's a dashboard with two options, to sign in and sign out. We have barcodes on our visitor badges. These are assigned when the visitor badge is assigned to a visitor before arrival. When our visitor signs in, we want to have a dashboard with two…
-
Sumifs Smartsheet multiple criteria assistance
Hello, I am needing assistance with trying to create a formula in Smartsheets that will count the duration of time for a specific Person/Year. Any help would be appreciated. EX: Data Sheet: Metric Sheet: Looking for a return on the Metric Sheet to read:
-
Two columns match calculate columns
I am trying to sum from a separate sheet if Columns A and Column B equal criteria sum Column C... but having problems.
-
Sending a notification when all checkboxes are ticked
Hi I am new to using Smartsheet and am still learning. I need to set up an automation where if all the checkboxes in a sheet are ticked then a notification message is sent out informing that all actions have been completed. Could someone give me some guidance on how to set this up. many thanks John