Brand new to SmartSheet.  Looking for best method for nested IF/THEN statements to provide status.  Or alternate methods.  Example... IF column N has any value, THEN column B shows Status 1, IF column O has any value, THEN column B shows Status 2, etc.  My nested IF/THEN statement from Excel didn't

I have multiple customers, some of the companies are listed more than once because they contain different data. But, I also need a filter to filter all of them out except for one, is that

I'm fairly new to setting up my own SmartSheet pages and was wondering if this would even be possible. Is there a way to link a Date column to a check box or a drop down item?

For example- I want to have it so that when a certain item is selected from the Dropdown list, a Date column would

Hello-

Is it possible to default to a different camera in Android app when selecting to take a photo.  By default the smartsheet app uses Android camera.  I would like to use Skitch so we can add notes, arrows, circles, etc. to the photo.  We are using this for a production line checklist.

THANK

My team and I are trying to implement our escalation algorithm in smart sheet but it would seem that SS can't compute natural log in formula.  Are we missing something; Why is the SS math library so dumbed down? 

Below is the formula in Excel we are trying to migrate.

I have a fairly simple Smartsheet with a report that uses just that sheet then the report is displayed on a Sight. The comments column displays on sheet and it displays on the report. But the Comments column is missing from the Report in the Sights widget. Is there a way to make the Comments (and

I have some formulas on the 1st row and everything underneath are indented in order for the formulas to work. However, when a new entry comes in via the webform. The new row does not indent automatically. Does anyone have any suggestions? 

Thank

We are looking for a way in SmartSheet to present all projects (ideally, can be sorted/filtered by workspace) and the resources assigned to each project, and the associated allocation in a calendar view.  I have created a quick mock up of the presentation attached.

No capability to do Reports in the

Maybe I'm missing it, but is there a notification that can be sent through the app when web form is

Access 2007... I am creating a report tracking spreadsheet. Basically consists of a column of report numbers (column A) and then different locations that report may be sent to with a checkbox column... if checked, the column next to it displays date it was checked. I would like to highlight a row if