Community

2

hi

I run a  smartsheet where users create smartsheet sheets to plan individual projects.

 

I have a list of all the sheets required.

 

I want to pull a report that compares the list of sheets required with the sheets actually created to track progress.

 

I can create a report which pulls them in as

1

Is there Task indent fucntionality in the Android App - if do please advise?

Seems to be restricted functionality relative to the Ipad App - hovering over app gives less options on Android v Ipad

 

ALSO certain colums appear locked such as End date and Predecessors  why?

 

Really this restricts me

2

I am creating task reports for our team that pulls tasks from multiple sheets and aggregates them into one, easy to read report. I'm using reports because I want to apply date filters and structure task reports to show all outstanding tasks (past due and due today) and upcoming tasks (tasks due

3

Hello everybody,

 

I am struggling with creation of formula for defining Invoice Status Symbol (RYG). Geeting the UNPEARSEABLE error message.

 

My formula is right now as follows:

 

=IF(TODAY-[INVOICE DUE DATE]11>30,"Red",IF(AND(TODAY-[INVOICE DUE DATE]11>5,TODAY-[INVOICE DUE DATE]11<=30),"Yellow",