-
Imported Formulas from Excel
Happy Wednesday! I have been going in circles trying to figure out where this formula is going unparseable. I researched it against other similar (working) formulas in smartsheet and the Formula errors guidance- but I am still missing it- hoping a fresh set of eyes can help me pick out the culprit. Thank you!…
-
Look up and sum costs of selected features
I am building a form and associated sheet/workflows to track requests for vehicles from our customers. I'm hoping to find a formula that would allow me to use features chosen in multi-select columns to look at a different sheet where the costs of each feature are organized, and return the total cost of all the features…
-
Updating Fields Based on Input
I have a form in which I let people enter in either a Monthly Budget or Total Budget. If it's Monthly, each Monthly Budget field obviously gets filled in with a value, but if it's a Total Budget, those Monthly Budget Fields are left Blank. Q: I know how to allocate the Budget for each month, but is there anyway to populate…
-
IF Function (related to dates)
Hi @ all, I have a formula issue where I would like to get your help. As you can see I have a delivery cell which I would like to link to my "Financial Year" cell based on the following condition: FY2020 = starting 01.01.2020 until 31.12.2020 FY2021 = starting 01.01.2021 until 31.12.2021 FY2022 =starting 01.01.2022 until…
-
WBS in smartsheet.
Hi. Is there a way that I can have a dewey decimal system kind of the numbering for the items on my worksheet. I have found a solution that lets me have items numbered in the format 1.1 and 1.1.2 and 1.1.2.4 etc. But I want a system where I can have the format 01.00.00.00 and 12.04.09.11 etc; How do I make sure that there…
-
Formula not working as in instructions.
I am trying to follow the instructions on the SUMIF formula page. I created a sheet with only the "Sold Date" and the "Transaction Total" columns, entered some data, and I copied the formula "=SUMIF([Sold Date]1:[Sold Date]3, MONTH(@cell) = 2, [Transaction Total]1:[Transaction Total]3)" and pasted into a Summary Sheet…
-
COUNTIF Checkbox Help!
Help!!! I'm trying to create a formula that counts a row if a column "A" value =X AND column B check box is checked. I have tried the following and it does not work. Any suggestions? =COUNTIF(Status:Status, OR(@cell = "Partially Invoiced", @cell = "Cancelled", @cell = "Contract Requested", @cell = "Contract with Client for…
-
Do formulas not transfer over to reports?
Hi everyone, I have a formula in my sheet that is not showing up on my report. It's a simple formula; how many days late something is, and I really need that info displayed in the report. Ideas, tips or tricks? Thanks! Ashley
-
Count how many formula questions
Hello All: I'm working on a product development sheet and we have products going live in different months, I created a column that has a drop-down for each month where I select the right month on the product row. The question I want to easily sum how many products we have lined up by month. What would be the easiest way to…
-
How To Use Formulas with Symbols for Sales Sheet
Hello, I created a sales projection vs actual sheet for 2021, I would like to use a formula with symbols to automatically change based on percentage. So if it's at 25% one, 50% one, 75% another, and by 100% show green, based on my column names, what would be the best setup for the formula? I greatly appreciate your help.