-
Formula continuously updates cell even though values are not changing
Certain combinations of results are continually updating even though the value/result didn't change. Every time I open the sheet, it requires me to save but I didn't change anything. Combinations with issue: "Utility, Telecom, Waste" and "Utility, Telecom" Combination without issue: "Utility, Waste" Services column is…
-
How can I append additional text to strings pulled via formula from other cells?
I am using a large function to pull together a list of names based on whether someone has provided an update. The formula that I am am using is basically… =IF(Input from Cell X = "", [Contents from Cell X1], "") + ", " + IF(Input from Cell Y = "", [Contents from Cell Y1], "") + repeat. This works but it gives me lists with…
-
Date value is off of Modified Date is off by 1
Something has changed. I have a formula =[Modified Date]@row that captures the last modified date and keeps it static. I do this as I have rows backed up nightly to another sheet if they were modified. Just using Modified Date doesn't work as the date changes once it's on the new sheet. It's now rounding the date up. The…
-
Refining a Smartsheet That Tracks Corporate Giving
My Smartsheet tracks our corporate donations requests [approved/denied, in-kind or cash, local or abroad, etc.]. I'd like the dashboard to reflect the top 10 focus area of approved organizations. Are there any formula(s) for that? The column type is a drop-down list. The values are as follows: Animal Welfare Arts & Culture…
-
Fix #INVALID COLUMN VALUE error when using Index Match in a different column type than source sheet
Hello! I am curious if there is a solve to the #INVALID COLUMN VALUE error I get when trying to pull a value from another sheet using Index Match, and both the source sheet and current sheet have different column types. I am currently using the following formula: =IFERROR(INDEX({OChM - Intake - Intake Meeting Date},…
-
Pull form responses into another sheet & display vertically
This discussion was created from comments split from: Tie data to pull into another sheet.
-
Item Changing with New Information Need Reporting Help
I have test for items a,b,c,d and a report that is pulling data from those tests. Occasionally I'll have an item that will turn to a version 2 now considered a2. Column information wont change. Now there will be an a, b, c, d, and a2 rows. What should I do to pull the correct information to my report now that a (the…
-
Project RAG
Hi I have a column formula that works out the project health RAG based on how complete the project is and how the actual end date is tracking against the actual end date (see screen shot below). Some of my RAGs are now blank but, I don't want to tweak the formula in case I mess up the other project RAGs, any ideas how I…
-
Calculating all possible variations of a multi-select column
I have a multi-select column where I am selecting all the teams I need to reach out to about a particular row of data. I want to streamline the number of meetings I schedule, so I am trying to calculate how many unique meetings I would need to create based on the different team combinations present. For example if I have 5…
-
How to create a Revenue Graph by Project Stage?
Hi All, I have this Sheet with 3 columns - I'm looking for a formula that will add up the "Gross Sales Rev $ - Yr2" column with criteria that the Project Stage is "In Progress" and Current Stage is "S1 - Intake." Once I have this formula I know I can easily replicate it to the other stages. Ultimately I can then use this…