-
Formula previously working (along with others) and not now
Hi all I have this formula in one of the summary sections for tracking the SLA of job completions as part of a number of others, mainly for the creation of graphs and percentages etc and a lot of them seem to have stopped working. They now say #INCORRECT ARGUMENT SET. None of the references have changed and I'm so confused…
-
Bring Data From Another Sheet (INDEX, MAX, COLLECT, MATCH)
Hello Community, I need to bring data from one sheet to another. I usually accomplish this using INDEX, MATCH combination. My challenge right now is the following: Sheet 1 has unique records. Sheet 2 references Sheet 1 on a unique identifier (taskid), but there might be multiple records in Sheet 2 for the same taskid. I…
-
Using Formulas with cross reference sheets
Hello, I need help adding one more criterion to this formula I am using to pull data from one sheet (Budget) and give me a total expense in another sheet (Staffing). =SUMIF({5320182 VENDOR}, @cell = [Last Name]@row, {5320182 EXPENSE}) This formula is pulling the data fine but I need to narrow it down one more time by…
-
Index Match is pulling correctly and then starts duplicating wrong values in cell
Hello, I am trying to pull in the email address from a master contact list into a different contact list with pay rates. I am using this formula: =INDEX({EMAIL}, MATCH([Full Name]@row, {FULLNAME})) and initially it is pulling the correct email address to the correct individual, then further down the page it starts…
-
Always refer to the first row in a sheet
I have a sheet where a form will create a new row at the top of the sheet with each entry. Is there a way to have a static formula or cell/row reference that will automatically default to the newest entry? Visually to have the yellow cell always refer to row 1 in the sheet even though I make the reference to what will…
-
How to reference Sheet Summary cell in the text of an automation?
I've been usign columns references in the text of my automations messages a while now. It looks like that. The text is in french but you can see the symbols used. Bonjour {{Fournisseur}} Voici la confirmation de commande pour le projet {{Projet}}. La date de début est le {{Date de début}} La date de fin est le {{Date de…
-
How to combine multiple values in a cell based on unique identifier
Hello, I've been reading through many different Smartsheet forum threads on how to do various formulas using Index / Collect / Join / Match functions, however, I have been unable to adapt any of the formulas I'm finding to do what I need to do. Everything either shows up blank or gives me error messages. Goal If there are…
-
Deleted unsused active reference keeps coming back.
I have waited at least a week and it still happening. The references are no longer being used. I have tried browser fixes and other optimization. This is happening on all sheets. I have confirmed that other users are also experiencing this. I will be reaching out to Customer Support but I would would like to know if others…
