-
Move Incomplete Tasks
I'm a new user. There was a feature in MS Project that allowed the user to move incomplete parts of a task to the status date. This allowed the user to see how tasks that were behind schedule would affect the overall schedule and critical path. This could be done on a task by task basis or by slecting multiple tasks. How…
-
Two SmartSheets
Hi.. I work at a Company that just purchased Smartsheets enterprise edition. Some of our userbase have been using smartsheets before the purchase. Before the Enterprise purchase we had two different groups with their own smartsheets setup. When the purchase was made one of the groups was upgraded to the enterprise version.…
-
Is there a way to make my folder structure setup the default for everyone on our account?
Thinking of this like file explorer so that all of the sheets are organized rather than in one long list for the users I add / share sheets to throughout the team. thanks
-
How to set calendar view permanently for a report
Hi, How can I set the calendar view permanently as a view for a report? And is it possible to display more on the calendar above the primary column?
-
IF/AND or ISBLANK formula?
I am trying to evaluate three columns for the ABSCENCE of data to return a value of "Delinquent". For example: I would like the top row of this image to reflect the word "Delinquent" when none of the boxes are checked. Should I use an ISBLANK formula or an IF/AND formula? And what would it look like? Any help on this is…
-
Changing Duration to Hours changes my Finish time
Hi all, I am having a problem that needs your assistance. Most of our projects are done in hours over a number of days. I have changed the Duration to hours instead of days in my sheet but what it then does is change the Finish time. How have you corrected this? Your assistance would be greatly appreciated
-
=SUMIF Help please:
Hi Team, Formula not working…(#UNPARSEABLE) =SUMIFS[Value of Job],2 [Sold Date:]2,>DATE(2016, 12, 31),[Sold Date:]2,<DATE(2017, 2, 1), [Result]2, 1 Trying to get “Current Month Sales” to calculate “Sold Date” when “Sold Date” matches the current month we are in (January) * * When February rolls over I wanted “Current Month…
-
Determine if Date is a Holiday
Does anyone have an idea of how to determine if a date is a holiday or weekend (if those are specified in the sheet) in Smartsheet via formula use only? The equivalent functionality I'm looking for is one row to have a check a box if the date column is a holiday or weekend day. I've tried a lot of "creative" workarounds,…
-
Filter to show Current User must be Contact List column
I noticed this new feature to show the Current User is in the Jan 17 2017 Product Release, but I dont' think the Help Article has been updated on this...maybe I missed it. To clarify, if you want to use this feature to create a Filter that shows the current user logged in, you must set the Column type as a Contact List. I…
-
Google Contacts Import
The Google Contacts import process needs some fine-tunning. For those of us that have several hundred or even thousands of contacts, we need a way to filter the import. A couple of suggestions: 1. By Google Group: this will allow us to select which group to import into SS. 2. By query: say I only want to import everyone in…
