-
IFS statement with a date from another cell
Hi, I am trying to create a formula with dates that will change each month to the start and end date of the new month, so I was hoping that I could link the start and end dates to a cell in the Smartsheet which have the correct dates and will be easy to update rather than changing each formula each month, but when trying…
-
RankEQ formula by group
Hi, I'm hoping to make the RankEQ formula have a criteria component to the ranking to rank overtime on deck per shift instead of by the whole group. We keep all the information on a larger spreadsheet and have a ranked report available to all staff. The column headers are below: Thanks for any help!
-
Stock Market Data
Hello Everyone, Wondering if anyone has created a sheet that pulls stock market data (share price, market cap, etc.) directly from the internet. Thanks for your help. Shawn
-
VLOOKUP to another sheet - cannot pull these fields into a report, getting #ERROR
I am using VLOOKUP in a sheet (call it Sheet2) to pull data from anotther sheet (Sheet1). Then, I'm creating a report that pulls data from Sheet2. This report is pulling some of the data from these VLOOKUP columns. I'm seeing an issue where the report can only successfully pull data in sometimes. Sometimes I open the…
-
Auto Generating a Sequential Document Number Based on Cell Criteria
What formula can I use to auto-generate a sequential number into the Document Number column for each row based on the information placed in Company, Department, and Type? I need the numbers to look like this: PBI-ACT-FRM-0001. "Company-Department-Type-Sequential Number" We have several Department and Type options in a…
-
Trouble creating exact match formulas to list tasks associated with specific departments.
I'm working on a set of formulas that will find the tasks and list them for the exact matches of the below Department names (among many others). I' have a formula that will work for a few of them but not all of them. As you can see they have similar letters (EDI and IT) and the results they return overlap each other, or…
-
Allow automation to populate cells with formulas.
For some reason the devs have blocked using =formula() and they populate cells with '=formula() when you try to use the features in conjunction. This makes your formulas inert and is quite frustrating. This seems like such a easy way to increase efficiency in the program and should be implemented immediately. Thanks for…
-
If name in this column, put contact in another cell but not the cell with the formula
I'm using the Jira Connector and having a heck of a time getting contacts to sync. I've been through a laundry of ways so now I want to try this. I'm able to bring in the Assignee Display name with no issue in a text column only. Jira connector will fail if a column has a formula (so frustrating, let me tell you!), so I am…
-
Is there a way to set up a SUMIFS formula that will ignore the search for criteria if needed?
I need to set up a SUMIFS formula based on 5 pieces of criteria Business Category Brand Product Name Customer However, is it possible to set up formula that would ignore the need to search for all 5 criteria if any of the criteria are blank? For example, if I wanted to the sum of all products for a specific customer…
-
Formula to SUM = 0 Why?
I created a formula to sum the values in other formula columns but the return is "0". I have created other sheets with the same type of formula and the return is correct. How is the return 0 on this formula. It appears to be correct.
