-
Copy unique email address then sum entries question
I'm relatively new to using Smartsheet, and I have a question regarding a formula I'm trying to create. My colleagues and I are tracking our steps for a work event, and I've set up a sheet and a form for them to submit their work email addresses, dates, and total steps. What I want to achieve is a formula that can…
-
Assistance with Join collect with multiple criteria and evaluation action
I need to collect the email if the position is either Position 1, Position 2 or Position 3, and the status is “FTE” And If the status is “Open”, then collect from a helper row I built with a different email. I got a single position to collect but am struggling with multiple choices and the evaluation if is “Open”.…
-
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.
-
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…