Community

Unfortunately my work email address is on-premises Exchange Server so I cannot use the Outlook Plug-in (very disappointing as that would simplify my world tremendously). So far I have not seen an alternative such as a unique email address I can forward emails to auto-add to tasks in smartsheet (such

Hi, looking for some help please.

I want to count a financial figure when the status is not received.

Columns i am using are Start up budget and Received status.

Probably really easy for someone, but am struggling with formulas as quite new to Smart Sheets.

Any help greatly appreciated.

Thanks

When working with a formula, some errors do happen and the formular doesn't work. Does smartsheet have a feature like excel which would show a part of formular that is missing something or has a problem?

Also in excel, before you hit Enter in a formula, you could highlight part of an argument or

I am trying to use the Smartsheet API on nodejs (v8) on windows. When I add the smartsheet npm package, my solution no longer compiles. Easiest way to reproduce (though it reproduces without using create-react-app):

> npx create-react-app solutionname

> cd solutionname

> npm start

It works - your

Has anyone created worksheets to keep track of Client tasks for an accounting Practice?

Trying to keep up with all of the assignments and tasks in one central place

Hi. I need a way to post project updates (such as weekly meeting key points) on my project tracking documents. This is to keep team members updated on the latest happenings of a project. 

The obvious solution is to simply create a dedicated row towards the top of a sheet and place the news in a

Hi 

Been struggling with this for ages, I can get the two elements of this formula to work separately but not together - I hope the below makes sense! :)

I am trying to get a formula to:

A) Search a column on another sheet to see if a reference number is present

The below works but gives me the

When I import a csv file with a numeric column but more than half of the data is 0 or 1's, the column becomes a CheckBox column.

Less than half and it is (accurately) a Text/Number column.

Either the threshold should be much lower, or any non-Boolean number should force the column type to be

Hi all,

I am running into some trouble iterating on this formula which was a countifs with an "AND." I am now trying to add an "OR" to the first part. I want to see if the Range 1 contains "Zebra" or "Lion" and was entered in the last 90 days. After scanning these communities, I have tried this

I have been wracking and wrecking my brain trying to figure out a formula that will go ahead and automatically display the date of the last work day of the month taking into account weekends and holidays that will automatically calculate based on today's date.

Any