-
Calendar view from multiple sheets
HI I am new to Smartsheet and I basically want to use Smartsheet to create a schedule for my business and life to be seen in a calendar and Gantt view. Before creating my sheet/s I am in a dilemma if to create a different sheet for about the seven different projects constituting my business, or to create one sheet. The…
-
Formula Help
Hello New user needing help with formula. I would like it to be something like this: When the due date is => than today -1 turn red, if the due date is < today - 3 days turn yellow, if due date is is =. than today +5 turn green The idea is if a task is due today or tomorrow its red, if a task is due within 3-5 days its…
-
G-Suite reply in comments
I successfully have my emails in Gmail landing in the comments in a particular or new line in a sheet, works great and very helpful. I see in the added email in comments a "add reply" blank. Does this reply just stay with the comment or does it go back out to an email Maybe this is a wish list type of thing, but if a…
-
Transferring ownership of workspaces
Hi I have been assisting a client in setting up a workspace containing folders, sheets and reports. I have joined them into my team account for this purpose. Now they are ready to continue on their own and are setting up their own Smartsheet account. How do I transfer the ownership of this workspace to them so they are no…
-
Primary column
A new user is wanting me to verify that you cannot reassign the Primary column once your sheet it set up and saved. I'm pretty certain the answer is "no." Blessings, Loann
-
Feature Request
I have used Smartsheet for years and find it to be the best Project Management platform to date. I have a few features I'd like to suggest be added in the near future... please note if you'd find any of these helpful too. Hopefully this will help grab Smartsheet Developers/Engineers attention. - "View As (Other User)"…
-
Working Offline
Hi There, Fairly new Smartsheet user here. I've read back few a few pages of questions and done a search, but couldn't find anything on my problem. Does anyone have a solution for working offline on their sheets? We are migrating over to Smartsheet for our project management and I need to compile new sheets for 5 major…
-
What to do when project ends?
Hi Smartsheet Community, Our company works with customers on projects for a set period of time. When a project is complete, we archive completed projects for internal use, but we no longer need our customers to view or edit sheets and sights in Smartsheet. When a project ends, is there is way to inactivate or close our…
-
if-then-else logical function
I have a symbol column valued ( green, yellow,red). I want to set the color based on a logical formula as follows: There is Start and a Finish date columns. if ((Start <= Finish - 8, "Green"), IF(AND(Start > Finish - 8 , Start <= Finish), "Yellow"), IF(Start > Finish, "Red") Anyone, can you correct this? Thanks Art
-
Temporarily Suspending a Licensed User
We require our licensed users to conduct semi-annual user access reviews on their Smartsheets. They need to remove users who no longer need access rights and delete or archive smartsheets that are no longer needed. (See attached jpg) If they do not complete their review, I want to suspend their rights to Smartsheet until…
