-
A unique number based of off criteria
Good morning all. I have a challenge for everyone. I need a unique number based on the previous rows unique number that can then be influenced again by another criteria. The "Number" MUST always increase. The "Identifier" column is the column in question. I have tried multiple was to populate this but I either get a…
-
Date Formula
Hello, I am trying to create a basic formula where I need to calculate a date that is 18 months after a date in another column. So again, one column has a date— the one I need the formula for should be the date plus 18 months. This seems so basic…been all over Chat GPT and other sites to figure this out but no dice. If you…
-
Question About “=[]#” Formula in Smartsheet Template
Hello, Our team is reviewing one of Smartsheet’s templates to manage marketing campaigns. The template includes multiple sheets, reports, and a dashboard. However, in the Plan sheet, there’s a column formula that reads: =[Campaign Name]# I’m trying to understand what this formula is doing. There isn’t a column named…
-
CountIfs Formula that Counts Multiple Columns, each with Multiple Values in Each Cell
Could someone please help me correct the following formula?: Formula Goal: COUNTIFS formula that reviews over 10+ columns, each cell can contain multiple values ("Allow multiple values per cell" designation) — What is a formula to count a specific combination? My Example Formula (that doesn't seem to work):…
-
Error when Referencing another sheet
I have created a summary sheet that uses a formula to build out, and I am having an error when trying to reference another sheet. I have done this in the past, and it has worked. It seems to be a bug, but I wanted to confirm.
-
Pre-Filled Forms Using URL Queries: Tips and Tricks
Using URL queries to pre—fill forms seems to be catching on a bit more lately. There are a lot of resources out there, but they can be kind of spread out, so I figured I would start a thread that has some of the lessons learned, tips, and tricks that I have discovered along the way. Tip #1 [info callout] The first one that…
-
How to Sum a total excluding numbers before a "0"?
Hello, I am looking to add a formula where we rollover the total points each quarter if the quarter is greater than zero for the prior quarter and add only the total points documented after there is a zero listed for a quarter. For instance if someone receives points in Quarter 1, no points in Quarter 2, but has points in…
-
Cell value for main or subworkflows.
I am trying to create a formula or workflow that changes a cell value to a value in another cell. I tried with workflow, but I can only assign a text or specific value from a drop down. But I want to assign a value from a specific cell. Formula would help, but this then needs to change depending if the cell is already…
-
Need local time based on City & State
I am building a solution whereby I need the local time based on City and State. This is a lookup sheet whereby a store # is input and formulas return address, phone # and contact. I need to include the local time as well. For instance if store is located in Dallas TX then I need local time in Dallas TX. However, if store…
-
Need a solution for Parsing a value within a block of text
I have a schedule that automatically adds appointments from teams. Because of the way the data is retrieved it will pull all the meeting info into a block of text in the "Task" Column. I am not sure how this is done but I know its done using a bot in MS teams. Task column will always pull data that looks like this (without…