-
Checkbox, Texts, RYG
I am trying to create a formula based on checkbox and dropdown list column. The result I am looking for is for Column 3 to have either a Red or Green symbol based on if Column 1 is checked OR Column 2 includes a specific word. Column 2 is a drop down with multiple options. Is this possible?
-
How do I add text to a formula
My current formula below works, and returns the value, 25%. But I want to add specific text to the value returned. So it should read, 25% - Milestone 1, or Milestone 1 - 25% =INDEX({Milestone 1 - Preliminary Design Range 1}, MATCH([Activity ID]@row, {Milestone 1 - Preliminary Design Range 2}, 0)) Thanks.
-
Trying to combine 2 AND functions with an OR
Hi There! I am new to SmartSheets and am working on a way to automate a process using the OR with AND's and running into trouble. Basically, I am trying to check a box in a column if any of the following is true. If the Model type is 1 AND the version is less than 9 OR If the model is 2 AND the version is less that 18…
-
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?
