-
% 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…
-
Results shows #UNPARSEABLE
Hello! I recently came across a very helpful answer from here: https://community.smartsheet.com/discussion/99468/if-a-value-in-a-cell-equals-the-same-value-in-a-column-from-another-sheet I have applied the formula to my sheet, but it was returning UNPARSEABLE. I tried another column and it works fine. Below is the value…
-
Weighted Average Summary in Reports
It would be extremely useful to be able to summarize columns by weighted average in a report. Currently only a general average is available which can skew metrics that deal with percentages. Maybe even provide the capability to input custom formulas for certain cells or columns?