-
Worksheet with more than 20 sheets cannot be imported
If Smartsheet only imports the first sheet in a workbook, why does it care how many other sheets there are??
-
Deleted users in "assigned to" resource management sheets
What happens to sheets that are resource management enabled and have "assigned to" columns with users that have been (subsequently) deleted from our account? Is there a best practice on how to maintain assigned to data from deleted users for archival/reference purposes? Will resource views still function? Reports?
-
combining multiple sheets at months end
I have sheets for each representative, but at months end I'd like to combine them for a master working list
-
restrict data entry of a column to only admin
Hello, Is there a way to restrict data entry of one column to only the admin? but other people viewing the SmartSheet are able to view but are not able to make any changes to the column that is restricted? Please let me know, thank you!
-
Parent Row Formula Based on Children's Status
How do I use a formula in my parent row to update based on the children's status? I want the parent row to to "Active" if any of the children are "Active", "Complete" if all of the children are "Complete, otherwise, "Inactive.
-
the start of a squeeze? what is the community view?
The email below is the start of a squeeze, the direction of which I’m uncomfortable with and which is ultimately designed to force the switch of collaborators into license holders. Removing ‘View Cell History’ from collaborators is a particularly unwelcome surprise. From: Smartsheet Team <productinfo@smartsheet.com> Sent:…
-
Formula Help!!!
I can't get this formula to work. Any glaring mistakes? =IF([Date Received at Settlement Desk]1) = "", "", IF([Date of Payment]1 = "", NETWORKDAY([Date Received at Settlement Desk]1, TODAY()), NETWORKDAY([Date Received at Settlement Desk]1, [Date of Payment]1))) Thanks!
-
Indefinite Lag Times?
Hi, I am trying to set up some predecessor relationships between tasks that don't have a definite lag time associated with it. I just need the relationship to require Task A to wrap up before Task B. Task B doesn't need to start immediately after Task A is done, but it CAN NOT start before. For example, I am doing a…
-
Status Bubble Not Changing Based on % Complete Formula
Hello, I am currently trying to find a way for the Status bubbles to automatically color based on the % Complete column. Reviewing other posts I found and have tried the formula below, but it only works correctly for Red and Grey. When the percentage is above 51 or at 100 the color remains red. =IF([% Complete]2 = 0,…
-
Splitting user stories to new iteration/sprint
For sprint tracking and planning, I'm wondering what others are doing when they need to split a story that isn't finished in the last iteration/sprint. For example, I want to be able to track that the story was worked on previously in sprint 3, was put on hold for 3 months and now is being worked on again in sprint 6.…
