-
Out of Practice, Need 2 Variable Flag (At Risk) Help
I haven't been a good girl practicing my formulas. Everything I've tried is coming up Uparseable. What I'd like to do: Red Flag when "Expected Completion Date" is within 5, days, or in the past, and "Current Status" does NOT equal "Complete". I'm feeling pretty silly that I've spent so much time trying to get this to work.…
-
INDEX MATCH formula - not working
-
How to Add Specific Field into Form with SUBSTITUTE Formula
Hey Community, I am trying to have my OPPTY # field prepopulated in my form using the SUBSTITUTE formula because a lot of our users tend to enter it incorrectly. Can you please help me figure out how to solve this? I will paste a screenshot of the format below.
-
Need to calculate number of days but only if there's an entry in both cells.
Hello, I have a formula to calculate the number of days between two cells (Date Filed and Date Resolved) but can't figure out a way to keep the #InvalidDataType message from showing if the matter is still open and there's no entry for Date Resolved yet. You can ignore column 10 in the image. That's just me messing around…
-
Pull data from a source sheet to a destination sheet with one condition
Hi there. I have an issue and I would like your help please! You can find below the Smartsheet I have: I have a 1st Smartsheet "Source Smartsheet". In this Smartsheet, I have a list of projects with one line per project and multiple columns that are used to save the data for each project. I have one unique ID per project…
-
Formula for Days to Complete coming up #UNPARSEABLE
I'm trying to calculate Days to Complete with the attached columns, but it keeps coming up #UNPARSEABLE. Any idea why? Am I missing something?
-
Formula to add 30 days to create date and insert into a cell is if value is blank
Good morning. I have a sheet where we are placing dates for follow-up on projects that go on hold. In the form we ask for a planned restart date but sometimes this is unknown. When that date is unknown we want to trigger a reminder for follow-up 30 days after the date the row is created. I have a created date field and I…
-
SUMIFS Formula Help
Hi there, Super stuck on how to get the below working, any help/advice about where I am going wrong would be greatly appreciated. Smartsheet 1 - Data Sheet, where: Range 1 = Dropdown list column Range 2 = £ value Range 7 = Contact Column Smartsheet 2 - Summary Sheet, where I am building formula (hence the References above)…
-
Possible to use cell linking for formulas?
I have multiple sheets that are set up in the exact same way, used by various team members. Each sheet has several formulas. If there is an update to the formula, I have to go into each sheet and adjust it. Is it possible to have a reference sheet that houses all the formulas and use some kind of link to reference the cell…
-
JOIN DISTINCT CHAR(10) List on Sperate Rows
Hi, I have the following formula which collects a list of a dropdown column, and removes duplicate values, is there any way that the returned list of values should be on separate rows of this column formula? =JOIN(DISTINCT(Dropdwn:Dropdown), CHAR(10)) Thank you,
