-
Column Formula Question
Is it possible to convert a cell formula to a column formula if it references a different sheet? Here is the formula in question: =VLOOKUP([Project Name]@row, {AM Master Info List Range 2}, 5, false) Where [Project Name] is a column in the current sheet, and {AM Master Info List Range 2} is a range from a different sheet.…
-
Counting Number of Installed Stores
Hello Smartsheeters, I am trying to count the number of installed stores using Smartsheet. I was able to use COUNTIF to get the number of chains that are installed by parsing the "Status" column: =COUNTIF(Status:Status, "Installed") However, I have another column that lists the number of installed stores/branches per chain…
-
Counting dates by week, months and year formula
Hi, I have a SmartSheet which logs enquiries. I need to create KPI report to measure the number on enquiries that are logged that day, this week, this month, last month, and year. Also a monthly running today for example Jan = 40, Feb = 50 and so on. Below is a screenshot of my Smartsheet and the column used for the date…
-
Formula no longer working
I have had a formula written for over a year and it just broke this morning saying it is now an #invalid operation. =City@row + ", " + State@row + " / " + [Location Number]@row + " - " + [Comp Short]@row
-
Conditional quantities for pricing sheet?
Smarties, I am creating a pricing form and am stuck on a formula. In the example, the first 4 widgets cost $10. Each additional widget is after 4 widgets is $3. In the preceding cell [1-4 WIDGETS], I have a single-select dropdown of 1, 2, 3, 4, 5+ (as I need these numbers to count the number of widgets sold for another…
-
If and Find
If cell A3 contains "ABC" then enter "ABC" in cell A1. Can someone help me do this in smartsheet? I tried using =If(find("ABC",A3,)="ABC","ABC","X") but its not working. Thank you
-
Formula Interferes with Form Data
I have a sheet where the first row is full of SUM(row2:row40) functions. This sheet has a Form that submits new data and I want the new data to be included in the totals at the top. I only have 10 rows filled so far, so I expected a form submission to show up on row 11. Instead, it shows up on row 41 so it is excluded from…
-
Using IF and CONTAINS in one formula
I am trying to create a formula that returns: Tolerable if the answer is Low Tolerable if the answer is Medium Acceptable if the answer is High Acceptible if the answer contains Urgent. I need to figure out how to use "CONTAINS" because some answers have dashes and other things that mess up the formulas. =IF(Answer@row =…
-
Date Formula Issue: #Invalid Value
I am a complete novice and I have been tasked with fixing someone else's formula. I have seen a number of responses to similar problems with other people but their solutions are not working for me. My formula is supposed to calculate a date 3 months later. For example, in column 1 the date is 10/01/2021. In column 2, the…
-
=COUNT(DISTINCT(COLLECT formula
Hi, I have a =COUNT(DISTINCT(COLLECT formula that is working in my sheet summary area. However when I try to recreate it in a metric sheet that pulls data from my sheet it only counts 1. Here is the formula that is working in my sheet summary. =COUNT(DISTINCT(COLLECT(Customer:Customer, [Who is your audience]:[Who is your…