-
Nested If Statement
Hi Team, Below is two screen shots. To explain this simply, When I have anything in my drop box with /xtra (Type Column) I want to have my totaling cell (Bottom of sheet) add up the Product Rate cell in that row. When its /Course or anything else I want it to add Cost Rate cell in that row. So my totaling cell (Bottom of…
-
Problem with Gant Chart - Gear Icon not consistently shared
Hello All, The gear icon that I see in my gant chart schedule, is not showing up for certain people that I share the sheet with. This is a problem as our project managers need to be able to change the time line displays. Some people can see it, some people cant. I can not find the setting to always allow the gear icon to…
-
Multiple vendors and corresponding part numbers
We are using Smartsheet to manage inventory. We purchase the same materials from multiple vendors, depending on pricing and availability. Is there a way to list the multiple vendors with their corresponding part numbers without indenting lines for each vendor below each and every item? The time required for that solution…
-
Can I use a button instead of a link?
Our training department uses a smartsheet embedded in the intranet for its training calendar. Click on a class and the description pops up with a link to the registration page. I'd love to replace that link with a SIGN UP or REGISTER button. Is that possible? (I'm brand new to Smartsheet, by the way.) Thanks! /shel
-
Group View for Resources showing as 'Portfolio Template'
Hi all, So I have several projects located in a 'Portfolio Template' and I want the group view to show the Project name rather than the sheet name which is 'Portfolio Template'. Is there any way i can change the group view to show the project name rather than the sheet name?
-
Gantt charts open at earliest date for collaborators
Is there any way to have collaborators being able to open gantt charts at today's date instead of the earliest date?
-
Indents
Hello. I am new to smartsheet and am trying to indent as follows: -parent level -child level 1 +1 +2 -child level 2 I cant seem to get it to allow me to indent the child level 2. (see the in process indent on the attached) It is making child level 2 an indent of child level 1 instead of an indent of the parent. Any ideas?…
-
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…
-
Multiple predecessors
I have multiple predecessors between lines 19- 29. Is there a way to add all these in without having to type each and every line #. for example- I want to avoid having to type in the predecessor field, 19,20,21,22,23,24,25,26,27,28,29 is there a shortcut to do this?
-
ISNA transfer excel formula to smartsheet
I am trying to create a template in Smartsheet that was housed in excel. There is a bit of a complicated formula I am trying to transfer and having a heck of a time. Here is the excel formula: =IF(ISNA(MATCH(5,'Project Assessment'!G6:G22,0)),IF(ISNA(MATCH("High Risk",D8:D10,0)),IF(B11>935,IF(ISNA(MATCH(5,'Project…