-
IF HAS Formula to Return Email in Contact Field
Hi, I have a sheet that includes a multiselect contact field with RA names (On-Site RA(s))and a second contact field (Manager). When joesmith@email.com is one of the emails in the On-Site RA(s) field, I want maryjones@email.com returned in the Manager field. I have added the IF HAS formula you see in the example in the…
-
Mapping data within a hierarchy
Hello, I hope you are well. I'm trying to find a way to collect information within a hierarchy on a sheet. I need to gather the last date for a column within a level of the hierarchy and display this date in the parent cell of this hierarchy, regardless of whether new rows are added during the project's development. The…
-
SUMIF Formula ?
Hello! I am trying to make the following formula. If "Actuals (Cash-In-Hand)" is greater than "Budget" list the overperformance difference in "Over-Performance". If there is an underperformance it should stay $0.00. In this case the overperformance is $1,185,852.00. Thank you for your help!
-
New user here... Need formula on how to count how many entries in a column are in a specific month
Hey there, I have wracked my brain for hours trying to find a formula that will allow me to count how many cells contain the month Jan, Feb, etc. So far I have tried the following.. Please let me know how I should adjust: =COUNTIFS({[ Range 1]}, @cell >= DATE(2024, 1, 1), {Certificate of Destruction Range 1}), @cell…
-
Date Percentage Formula Help
I need help with a formula. I have two date-formatted columns ("Archives Start Date" and "Archives End Date") and I need a formula that displays essentially "as of today, we're X% of the way between those two dates". Any help is greatly appreciated.
-
Remove duplicates from a row?
Is there a way to remove duplicate zip codes in a row of columns so only unique zip codes will be available when I concatenate them all into a combined zip code column? Example: If I have 4 columns of zip codes and Col 1 and Col 4 are duplicates, I only want to show Col 1's Zip Code once when I combined all the columns…
-
Formula not displaying percentage
I would like to display the most recent data from a cell in the metadata section of my Status Tracker sheet. Every week someone will manually update this information by adding a new date and then manually entering the percentage complete. All of the information at the to pulls in the most recent update in all of the cells…
-
Formula to get best poll time
I have created a poll with dates as column headers and several times as multi-drop down options. It created a fantastic web-form I was able to share easily with collaborators both inside and outside my organization. My question is, is there a formula I could apply in the Sheet summary to count the best time for each date,…
-
If cell is blank copy value from other column in same row?
I have a form our Sales team uses for customer interactions. I'm trying to work around the inability of Smartsheet to copy only specific cells from one sheet to specific cells in another sheet. I thought if my workflow copies the columns from the source sheet with the form attached to it to the destination sheet and then…
-
if function with dates
Hello fellow people @Paul Newcome @Genevieve P. @'in you both as you always been helpful to me i have a list of dates in a date column as per screenshot below I need to know out of which of those are within the next 12 months i would really appreciate your input please