-
Email to Name Automation/function
Hi, Is there a way to change an email, entered into a cell, to the name of the person? I figured that I could created an address sheet and use a cross-sheet, matching/index, formula. However I am hoping that there is a more simple and less time-consuming way. Any information would be helpful, thank you!
-
Adding a condition to recognize if the external reference cell has any data or no data at all
I have a metrics sheet that pulls data from another sheet. I want the formula to mirror the way the Filter feature works to say "if this cell has any data whatsoever in it (in this case any name) then count it. if the cell has no data, then don't count it." This is how I have started my formula: =COUNTIFS({Post Closing…
-
Choose Older Date between 2 dates and then calculate # of Years
Hi everyone! I have a list that shows hire date and in some instances a rehire date. I want to be able to calculate the years of service based on which ever date is the newest. See snip. This is the formula and it calcs correctly on the hire date, but returns blank if there is a rehire date. What am I missing?? =IF([Hire…
-
How to create a SUMIF with ISNUMBER
I am trying to add three separate columns together, but sometimes, one column will have text in it instead of a number. Is there a way to get the formula to exclude anything that's not a number? My brain isn't functioning high enough to come up with something that works lol. This is my current formula: =IFERROR(Rate@row +…
-
Can I populate a multi select contact list off of what is selected in a multi select drop down?
I would like to populate a multi select contact list in the Master Sheet below based on what is selected in a multi select drop down (Project Requirements). The Lookup Sheet on the right lists what should be populated based on what is selected. It's only reading ONE project requirement. Any assistance would be greatly…
-
Identifying Duplicates
I am working on a sheet that contains IP addresses. When reports are added to this sheet, I am currently going through the data and marking any duplicates. I want to find a way to either use conditional formatting to highlight the duplicates or any method that is available. Is this a possibility without inputting the value…
-
Formula for RYGB Status
Hi, I'm currently using this formula for status health but it's not the best because "Not Started" status is not showing Red if the End Date for the task is in the past. Obviously, the task is overdue even if it hasn't started. Can anyone assist to make this formula better? =IF(Status@row = "Complete", "Blue",…
-
RYGB health changes on date and status
=IF(ISBLANK([End Date]@row), "", IF(Status@row = "Complete", "Blue", IF(NETWORKDAYS(TODAY(), [End Date]@row) < 0, "Red", IF(NETWORKDAYS(TODAY(), [Start Date]@row) <= 6, IF(Status@row = "Not Started", "Yellow", "Green"))))) Goal: Health RYGB balls. -red, end date past due in any status -yellow, start date <=6days of today,…
-
Insert approvers name and date/ time of approval
Hi all, I have created a form and a workflow for approval. In short: Somone submits a form Details email to an approver Approver either approves or declines (would also be good to have more than 2 options i.e. defer) The smartsheet updates to say approved or declined What i cannot figure out how to do is show who approved…
-
Multiple Updates to a Single Row
Hello, I am trying to create a "tracker" that show the progress of a shipment that contains multiple steps that are updated as each step is complete. So essentially the Tracker sheet would pull all the new entry submissions and update submissions from the dump sheet, to one row on the Tracker for each shipment. There are…