-
Formula for Sum or just return a cell value
I am writing a 'difference' formula…the sum of cell 1 minus cell 2 is the difference. Easy. HOWEVER, if the value for cell 1 = 0 I want to return just the value of cell 2 and not subtract and get a negative number. Any ideas on combining these two? I know I'm close but I think I'm not connecting my formulas for IF and SUM.
-
Comparing Cell Contets
Comparing Employee names from FORM (no sign in required) in sheet with the Employee contact list Formula ? I have a master sheet that gathers: training Name and attendees names. i will like to generate the list of who did not attended the training. What is the best function to use for this? Many thanks,
-
Help with Countif Across Multiple Columns if the Row Starts with "Project Mangement"
Hello, I am struggling with a formula and hope the community can assist me. I've created a helper sheet to automatically pull in the month, day, and day of the week. The goal is to count the total number of green or blue symbols that occur in August if that row starts with "Project Management". For example, looking at the…
-
Help with a formula
I have two identical formulas except for a different cell reference. One works just fine, the other gives me an Invalid Data Type Formula. I can't find the issue
-
Using a formula to assign multiple contacts
Good morning! I am having a difficult time using a formula to assign multiple contacts. I have the checkbox selected to allow multiple contacts, but it seems as though when it comes to a formula, the cell is only seeing it as text. Example: Cell1 - megan@test.com Cell2 - jones@test.com Formula: Cell1 + Cell2 This then just…
-
How to parse a value from a concatenated field?
Hello! I have a column in a sheet that is being populated with multiple pieces of information from Data Mesh. As shown in the example below, the cells in this column contain multiple dates. I would like to parse out a single date from this column (Actual Deadline Achieved) into another column. I don't need the text "Actual…
-
Creating a technology device loaning process
Good day everyone. I am new to the community but not new to Smartsheet. Have been using at my company for a number of years now. My team has acquired a quite a few pieces of equipment and it seems that we are constantly loaning them out to other teams for certain periods of time. I have been working on a loaning process…
-
Index Collect with OR
Hi all! I would like my Index Formula to populate if the content of a referenced cell is A OR B. Otherwise I want IFERROR to populate 'Not found'. I get the separate formulas to work but when I try to combine them with OR, I get #InvalidDataType and #InvalidValue. I understand why I am getting the latter, but can't riddle…
-
Calculating sum of Receipt Totals from another sheet based on criteria of 3 columns
Hello, I am trying to build a metrics sheet to put into my new dashboard. This workspace includes receipts/ invoices that have been submitted by employees. On the Metrics sheet, I have the following columns- Branch, Field Cost Center, Charge Account, Auto Code, Total (YTD). I am trying to pull the receipt totals from…
-
VLOOKUP/INDEX return client name from master
Hello - I am trying to create a dynamic dashboard where a client name can be changed based on need. I watched a video on YOUTUBE and it was very good but he was indexing on numbers. I need to match on latest name entered into form. I am not getting results, have tried VLOOKUP and INDEX. I now it is likely a simple mistake…