Formulas
Discussion List
- 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 num…
- 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
- 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 …
- 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 li…
- 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 tha…
- 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…
- 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 c…
- 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…
Why is a text field only appearing in automation responses as the column title and not row contents?
Hello - newbie to Smartsheet! Have reached a roadblock I hope I can get your help with. I am automating a report sent to a manager after their team member completes a Smartsheet form. The team member …- Hello Everyone, Recently myself and two fellow Smartsheet Sales Engineers, @Lea Gikas and @Dave Stanley got together to create a WBS solution powered by Column Formulas. We wanted to provide the resul…
