-
Is there a way to get the Proof function active in the Dashboard?
Hello All, I have embedded the card view of my sheets into the dashboard directly but we are not able to access the Proof function. A message pops up saying m"Proofing is not Available". I have searched through all of the settings and I can't find a way to make the function available. Has anyone figured out a way to make…
-
Budget Health Status
Hello, I am currently using this formula to determine budget health: =IF([Projected Spend %]2 < 0.97, "Blue", IF(AND([Projected Spend %]2 >= 0.97, [Projected Spend %]2 <= 1), "Green", IF(AND([Projected Spend %]2 > 1, [YTD Actual Spend %]2 <= 1), "Yellow", "Red"))) I'd like to update it to the following: -On target…
-
Determining the predecessors
Hi In my project, activity activity A starts November 1 (the project start date), and finishes November 15 The activity A also depends on an intermediate activity B which starts November 5 and finishes November 8. Now since activity A is dependent on both -- the starting point and also activity B, how do I define the…
-
Who can change workspace sharing permissions ?
This article https://help.smartsheet.com/articles/522067-workspace-sharing?_ga=2.241258762.985620779.1605216901-1389174172.1605216859 states that the only people who can change workspace sharing permissions are the Owner and Admins. I just had a user with "Edit - Can Share" permissions delete most of my shared users from a…
-
Copy Value only and not the function
Hi, My second column has an IF function based on the first column that returns one of 4 possible values. I then need to preform another function (basic division) in a 3rd column based on the result in the second column. However, when I enter the function it returns a #INVALID OPERATION. Is there a way to just extract the…
-
Dynamic dates
I just read and commented on a question on dynamic dates from 2018. Hoping this has since been added to the product I have an immediate need to have all related dates update when I change the dates of of tasks and dependencies. Example, Milestone 1 will be delayed by 1 week, so I update the due date to 1 week later. I need…
-
Can items be set to reoccur on a set cadence in a Smartsheet calendar?
Can I set up recurring items in a calendar like a monthly newsletter or does each instance require a manual entry?
-
Email "From" text
Currently when I use SmartSheet notifications the From text in the email (not the email address itself) says "User Name via SmartSheet". Is there a way to change that and define it myself?
-
Selecting Hundreds of Contacts for Sharing
So if I want to grant View permissions to a sheet to a massive group of contacts--hundreds of them--I go to Share and then in the Invite Collaborators field I have to select each individual contact's name, one at a time? That can't be right. Surely there's a "Select All" checkbox I'm missing, or some sort of Share With All…
-
Reports
I have been using Smartsheet for ~8-years and to this point, I have had a master Sheet with data from about 20 Project Managers, so it was easy to create each of them a Report to pull just their data. I am now doing the same thing, but for our Global Account Management Team -- where we have several hundred Account…
