-
There are too many cells referenced by formulas in this sheet
Hi, I get this message "There are too many cells referenced by formulas in this sheet" every time I load a specific sheet. Then the sheet disappears & Chrome leaves this message: Aw, Snap, Error code: Out of Memory Would anyone have an idea how to tackle this ? I'll try to clean Chrome temporary files to get more available…
-
Pulling in selected data from another sheet when conditions are met & then marking that as used
I have a complicated use case I could use some help with. Apologies if I'm using the wrong words here; happy to provide clarification. Here's what I'd like to happen: User submits a form to request a voucher for a specific exam. Row in SmartSheet 1 is populated with user's data. Upon row population, another sheet…
-
% Complete and Symbols
Hello - does anyone know how to create a formula that when a certain symbol is selected, it will return a status? Screen shot below. -Empty; return status 'Not Started' -Quarter, Half, or Three Quarter; return status "In Progress" -Full, return status "complete" Thank you for your help!
-
Sum formula for Child cells
Hello Team, Please let me know the best formular to add up the values for Child cells, if some of the cells are blank or include 0 values. Below is a screenshot. I need to calculate the total value for each Region for the Stock Count. Many Thanks,
-
Help with index function
I have a separate grid with a 'Mapping Table' (screenshot below) with on the first column the values that can also be found in my final sheet. In the final sheet I also have a column that should show the mapped values. I'm trying to use the INDEX function to pull in the mapped values, and also show 'Pending' in case…
-
#Date expected error
Hi I have to two - "Target Going TAT Time (Day)" which is a text column and "Departure Date from Loading Point" which is a date column. Now I want to add them together in a column called ETA (G) = Target Going TAT Time (Day) + Departure Date from Loading Point The Problem i get an error when 1 of the column are blank, if…
-
How can I convert a date to plain text?
I would like to be able to use a formula to generate a date in a text field. However, when I try the formula, for example =TODAY() + 1 I get the error #INVALID COLUMN VALUE Is there a way I can convert this to text so I can I have it in a text/number column?
-
Calculating Dynamicly Average
Hi there , İ need a formula for a dynamic calculation , i added a sample as below , lets explain what i need ; At below table yellow field area contains August 2023 datas, white field area contains September 2023 datas , imagine that every each month , i amm adding new lines to this table also , So i have a dynamic tabe…
-
Find First Duplicate in a Sheet
I am trying to find the first duplicate value with the purpose of using that to highlight another cell; however, my attempts at the first part of the process have resulted in both #UNPARSEABLE and #INVALID COLUMN VALUE. The formula I'm trying to use mimics something I've used successfully in Excel: =COUNTIF($[Master…
-
Formula for Adding Sums based on Matching
Hello. I created an example for what I am needing help with. I need a formula that sums a column if the value at the row matches a field in another sheet with my current sheet. In my example, sheet 2 is where the formula will live - I need the grand transaction total for each clothing amount so in this example, the formula…
