Community

I think this is simple formula - but can’t figure it out.

I want a formula where if checkbox is checked, it puts the same amount as another extended column that I have.

If checkbox 1, then take # from extended amount in same row and x1 in that cell.

Does that make sense?

How do I set due date reminders for specific tasks (rows) assigned to specific people (assigned to).

As a default, I want a reminder to be sent to each assignee on the date that their task is set to begin (or, in the case, of a milestone, on that date).

I would also like to set a second reminder on

I love using the @email-address to send notifications to my team - thanks for adding this feature.

We have a large organization and I find that when I begin to type someone's email, Smartsheet presents a huge list of potential emails and it is challenging to find the right one since I do not have

Hi Smartsheet Team,

I am new to your tool and so far I find it very intriguing. I have a question though: We have organized our files in sharepoint libraries. And while I was happy to see the OneDrive support in smartsheet, I was a little disappointed to notice that when opening the OneDrive

I'm trying to dynamically change a cell's value depending if a checkbox is checked or not.  Directors of a project would like to know what stage a project is at and if that stage is on target or not.  Where I'm running into trouble is the directors only care about the Parent Task and not the child

Hello Smartsheet Experts!

Can someone show me a formula to use to automate the RYG balls in one column when a checkbox is ticked in another column?  Green if checkbox is ticked and Yellow if checkbox is not ticked?

Thanks so much for any assistance.

Hello all, 

Now that formulas can be used in the contact column - fantastic!  - what is the syntax to reference a particular contact value? -

I am trying to set up an IF <columnA value> ="blah" then assign contact X. I have tried using various strings for the true/false cases but am getting a

Hi all,

I am having trouble putting together a formula and I am hoping someone here can guide me in the right direction.

We have a sheet that we enter payments we receive from our customers. That sheet has the customer name, check date, deposit date and amount etc.

I am looking to create a

Hello, I am working on a form and was wondering if there is a way to not have a label for one of the sections.  Currently I am using the Section dividers to group the main questions so I don't want to use these again since the formatting would be confusing. but I have one question that has 2 smaller

I have a dashboard that I update weekly to show any applications that were processed through our office.  Sometimes, there are weeks where we don't have any applications processed, so I don't have any data for the week.  Is there a way to customized the error message in the chart? I've included a