-
Reminders based on multiple criteria
Hi, The only trigger available is based on dates which is fine but I need to add a condition such as "unless item closed". Do you know of a way I can achieve this, first of all is it a feature available? Thanks,
-
Collaborator
I have added collaborators to edit and view my smartsheets (some collaborators are admin & editors), however, when my collaborators log in they are prompted to upgrade or switch to free, my question is how do I stop this from popping up on their log in, and if they choose 'swich to free' can they still edit and make…
-
Printing 3 week look ahead schedule
Does anyone know it you can print a 3 week look ahead schedule? I have tried to print a date range ranging for 3 weeks but that does not seem to work.
-
Hyperlinking to templates
We have Project Tracking sheets with great detail, and we have project log sheets with a web form that saleman can fill out on their smart phones then submit and it populates into the Project Log sheet. I would like to link our project tracking sheet (template) to the new projects as they populate from the webform. Can you…
-
Smartsheet Business Case
I am trying to build a business case for my company to adopt Smartsheet, do you have something that could help me doing this? Like issues and how Smartsheet addresses them, how it can streamline busniness processes and projects. Benifits, uses, etc.. We are in Financial Services and Investments. We manage alot of projects…
-
Recurrent reminders
Why after i put the actual date on a task before the "planned date",it keeps sending me the reminder for this task although i already did it. Also ,why after pluging an"actual start date " it doesnt update the all other dates including the end date Thanks
-
General Ledger - Payments Tracking incl Budget Compare
Has anyone done a SS that incorporates a "form" of invoice entry (web part?), that after entering automatically logs to a SS tab, then can track budget vs. actual cost (and allow projections) for a project......MS Excel has a good template but without additional programming it only does one calendar year of…
-
Automatically populate a "STATUS" column with 1 of 5 values
I am looking to automatically populate a "STATUS" column with 1 of 5 values based on critera/conditions are outlined below. The key drivers here are the - [% Complete] - [Start] Date - [F/C Finish] Date - this is a column I have set up that uses a formula to predict a Forecast Finish ([F/C Finish] = (Today() + (R x D))…
-
formula help with symbols added
I have used a google form for time worked and synced it with smartsheet. I then have a column on my sheet to work out how many hours have been worked on a particular day using the information supplied on the entry from the google form. For instance if Joe worked 09:00 to 17:00 and entered this on his google form submission…
-
Copying groups of rows between sheets without losing the inter row dependencies
I have groups of tasks that ocurr in different projects and would like to copy rows that define those groups and insert them into other projects. When I copy them from one sheet to another, I lose the sequential dependencies between the copied rows. It takes time and and introduces errors to have to re type the…