I was working on a way to track some task hours and minutes... came up with this:

One of the problems I ran into is that if you put "00" (double-ought) or any minute with a preceding zero, it would error. You can see the work-around I made, not the most elegant, I admit.. If Smartsheet could ignore

Hello everyone!

I'm trying to make a formula that sums this year sales by month. I have this formula but it returns #INVALID OPERATION, would you mind helping me fix it. much appreciated.

=SUMIFS([Valeur TTC]:[Valeur TTC], CO:CO = "UD", Date:Date, IFERROR(MONTH(@cell), 0) = 1, Date:Date,

Can we use a contact list within a Form and allow multiple individuals to be selected like when working within the sheet

Wondering if it is possible to change a cell to "0" if the checkbox is checked. I'm assuming a formula will need to be used since I was unable to find it in the conditional formatting.

Hello Smartsheet community!

I have a sales sheet where new sales are added each day mentioning the amount and the representative. the sheet doesn't use contact list for representatives, just a simple drop down menu.

I want to add a widget to our dashboard showing total sales by representative. I

I'm trying to create a formula that allows me to count the number of times the word "Postcard", for example, appears in a list in a column. I am referencing a column in another sheet to do so. However, nothing I've tried works.

My instinct was to try =COUNTIF({2018 Open Enrollment Feedback Range

I'd like to create summary rows at the top of my sheet, but specifying the entire column as a range in the formula is causing #circular reference and #block errors.  Is there a way to specify a range from row 25 to infinity?  I'd like additional rows to automatically be included in my summary

Hi!

I have a tricky formula I'm trying to calculate, but with no success so far...

I have to different sheets that I'm looking on.

Sheet1: Planning and monitoring sheet

Sheet2: Work reports

The formula challenge:

In Sheet2 our guys at the field are reporting on different predetermined projects.

Hello everyone!