Community

Good afternoon. 

I am currently using Zapier to automate the creation of a project sheet once an initiative gets approved on a log. The current configuration is the following:

1. New initiatives are captured into a sheet called "Initiatives Log" through the use of a form
2. Approval of the initiative is

I'm having a difficult time making multiple 'If' statements work, cross sheets. I would like the sum of a column to be brought over to another sheet IF it meets the following criteria:

1. meets a corresponding category, and,

2. has a check box.

The first half works (below), without the check box

Hello,

Recently I have noticed that the smartsheet plugin for outlook keeps asking me to sign in evertime I open it up.

It's not hard to click the "Work Sign in" button, but I was wondering if there is anything I can do to remember me when I sign

Hello

We are using Smartsheets to build ships.. but I have an issue with the formula(S)

I want to be able to use a tick box for a formula.. 

We have many options priced and I want to use the tick box to generate option pricing. 

If the box is ticked then the price will move to the next column that

It is not supposed to count anything that is closed, lesson learned, or duplicate. 

The current formula is:

=COUNTIFS(Due:Due, <TODAY(), Disposition:Disposition, <>"Complete") 

This formula is counting those things, however, I need to count anything that is passed due and not closed, lesson learned

Hi, i am looking to make it so that I or others in the office are able to see all of the tasks assigned/items relevant to them in one place as opposed to having to click on every single sheet. My best understanding is that this is done through reports. However, lets say in one sheet the column is

When I import my MS project files into smartsheet it appears to lose information and change some of my start and finish dates. I have project but others in my company use smartsheet to view the schedules but the dates they are seeing are different. 

Anybody else have this problem and find a

Hi - I'm working in the agendas, and in the template, there's upcoming, past and new agenda submissions.  In the dashboard, it has previous agendas and upcoming agendas...

How do I get that to update to the next agenda?  The first meeting I did is over, do I have to make a new form for the next

Hello,

It would be smart to be able to add hide field in form with formulas.

Actually, forms add new lines, so in a smartsheet where you need formulas you have to add them after. Not very smooth.

Right now, to make my smartsheet a tool for users i have to ask them to insert line manually in

I have groups and sub-groups (I hope I'm using the right terminology, I have 8-rows indented under another row) and only the first four rows are totaling.  The calculation is for Duration and I am using days and hours.