-
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
-
Formula for identifying duplicate data between cells in two columns and noticing blank cells
Hello! As the title suggests, I am trying to think of a Formula that will tell me if there is matching data in the two cells in question. I have a Helper Checkbox Column for this and this is generally the formula I'm concocting so far. =IF(ISBLANK(Office@row), 0, IF(COUNTIF(Office:Department, Office@row) > 1, 1)) This…
-
Search all of Column A, for the value listed in that Column C, Return Value in Column B
Hi All, I'm having a bit of an issue trying to figure out this formula in smartsheet. I have a sheet with the following columns: Facility Name (Column 1: This is a listing of all facilities we are contracted with) Client ID (Column 2: This is a unique identifying number for that facility) Facility Parent Name (Column 3: If…
