Is there and EOM formula that will use the Month Column instead of manually using the DATE (2019,1,31) format?

Excel example:

=COUNTIFS(Type of Lead,"Servicing",Date Received,">="&B5,Date Received,"<="&EOMONTH(B5,0))

Smartsheet:

=COUNTIFS({Type of Lead},"Servicing",

Hi

I had a look but couldn't find the answer.

I am trying to do simple reports and formula Counts, but trying to ignore any duplicates.

Example below, I am only interested in counting the first time a name appears, so the count would equal 5 Names, ignoring where there is a second or third.

Names

When adding rows to a sheet, why does the Dashboard graphs not recalculate the graphs with the new rows?  Seems the only way to fix this is to back in the graph and select the new data rows.  Am I doing something wrong?

Thanks

Ok whats up with the graph colors??  I set the colors to the legend to what I want, BUT if I play around with changing anything from "Switch rows/columns" to any other item the colors change.  Very frustrating indeed!!!

Are there plans to allow colors to remain as set??

Thanks,

I have the entire column formatted as a percent, but when I enter 100, it shows as 10,000%, or when I enter 1 it shows 100%.  Would like for the number entered to show that percent.

Since this morning I get an error message when I want to download the login history. See screenshot below. 

Is that only me, or do other people have the same problem? 

Thanks

I have been trying to figure this out for hours with no luck. We've created a formula to automatically update our status column in our project plan sheets. We have specific parent rows that are designated as milestones. The milestone row status cells should update based on the status of the child

Would love to have S/M/L T-shirt icons to visually look at sizing.  This would be helpful as a project manager and on a scrum

Can you set a Stacked column bar graph to NOT show the total of numbers from columns, but just the largest number?

Example:

Drawn sqft       - 2,283,197

surveyed sqft   - 1,948,073

contracted sqft - 15,000,000

Currently the stacked bar graph shows a total for all three at the bottom.

Thanks,