-
Expected behavior for DATEONLY when embedded in other functions
I feel like the formula below should function to remove the timestamp off of the cell in created at the same row as the function, then count all cells in the created column in which the days are the same. =countifs(created:created,dateonly(created@row)) Currently this formula counts when the date AND time match. In fact,…
-
How to carry over Contact List value in grid?
Hello there, I don't know what happen but my contact list in column 'SPC Contacts' is not carrying over the contact value everytime I have a new row being added at the top of the grid. However, the column 'SPC Manager' is working and carrying over the value everytime a new row being added at the top of the grid. I checked…
-
How can I set my approval workflow to sent a copy of approval request email to me as administrator?
Hi, I have a approval workflow who sends approval request to the managers. But our corporate email sometimes treating it as clutter email and the manager is having difficulty to find the emails from automation@smartsheet.com. And to fix that, I want to have a copy of the approval request email so that If they lost the…
-
Use a Lookup to Return Multiple Matches?
What replaces/is equal to the "row function"? I am trying to look up data with various criteria and array those multiple matches into separate cells? Using the article and formula below, I tested it in excel with my data and it worked.....I just cant translate here. Can you use the example below as the demo when showing…
-
Can I have rows to automatically move up or down under different parent calls?
I am using a standard sheet with forms, in this sheet i have multiple parent cells. When my guys submit a form it auto adds the information to my main sheet but it populates at the bottom of the sheet. Is there a way to make a new row of information auto populate under the correct parent cell when it gets added…
-
Formula assistance
I have 3 columns (Health, Status, Due Date) and im struggling to get my formula right to activate the health symbol in my health column. Please assist. The status column is straight forward (In progress, Not Started and Complete). Please can someone assist?
-
IF Statement with nested AND, OR, and a Third Overriding Result
Hi Everyone, Notes40 contains a manually input numeric value that I'm using in a calculation to populate Notes70. Notes69 is a parent of Notes70, with a manual input of either "NA", "N/A", or no input. The result in the Notes70 calculation should display only if Notes69 is NOT "NA" or "N/A". Otherwise, I want Notes70 to…
-
At Risk Flag - Checkbox and Date
Hello! I am trying to have an 'at-risk' flag for this following scenario. If the "Onboarding Call Completed date is a date in the past, and the "PIP Finalized" column is not checked, I need the 'PIP At Risk" column to flag. I have floated to different threads but nothing I could put together got me to the solution I was…
-
Formulas will be the death of me-
Firstly, formulas will be the death of me. My coworker wants to to do this- If the overall plan is 25% complete and 25% through the duration = green If the overall plan is 50% complete and 50% through the duration = green If the overall plan is 75% complete and 75% through the duration = green If the overall plan is 100%…
-
Multiple IF in the formula
Hi all, i need help in the following formula. If [Due Date]394) = current month, return value as Current. If [Due Date]394) < current month, return value as Due. If [Due Date]394) = current month, return value as Not Due. =IF(MONTH([Due Date]394) = (MONTH(TODAY())), "Current"), IF(MONTH([Due Date]394) > (MONTH(TODAY())),…
