-
More functionality for for rules
The rules feature is nice but it is very limited and only allows to change things from different fonts, colors, strikeouts, etc. I would like a rule that allowed more detailed changes. For example, if column a says completed, changed column L to 100%. There are many different scenarios. We are unable to use the…
-
IF And
Good Day, I need so assistance, I am trying to do the following I want to change my Project stoplight Status Column (RYGB ball) to yellow if the following condition is met if my "# of Days" column is > 138 and my "% Complete" column is < 50% Here is my If condition - =IF(AND(([# of Days]2 > 138, ([% Complete]2 < 50)),…
-
Need help to upload new data from Excel to existing sheet
I have an Excel sheet that I pull data into from another system and then run a macro to organize it the same everytime. Is there a way to simply upload that new data over an existing sheet so I can use the new data to refresh/update a dashboard connected to that existing sheet?
-
Counting formula to see how many status each person has
So I want to see how many Not Started, In-Progress or Completed each person has.
-
Restrict a user's access to Dashboard only
I am new to Smartsheet but learning fast. We are starting a project to use Smartsheet for client onboarding to our software. I intend to create a client-facing dashboard but would like to restrict a user's access so they cannot click on the Home tab which they have no reason to view and is just a place for them to take a…
-
Calendar View
Hi, Smartsheet team: I would like to know what are the differences between the SS's the calendar view and the Calendar View App available for purchase. Is it possible to create a master calendar that gathers all the information of individual calendars into one place? Is there any chance to get a trial period for that app?
-
Block non-working days for resources?
Hello! I'm trying to schedule around vacation dates and other non-working days per resource, not for the whole team or whole sheet. How can I block off non-working days for a particular person without doing it 'manually' and messing up the dependencies? Thanks for any guidance!
-
Dropdown Menu Resrictions on forms
I created some Dropdown List fileds and I did not retrict the values. When I test this field on the forms it doesn't allow anything but the values available. Any suggestions? Thanks!
-
Symbol Column description
Can the description of each symbol be changed? Thank you!
-
Average of multiple rows
Hi - I am running into a problem with finding the average of multiple rows based on the two previous columns. I want to return the average of all the rows in column Fall Rate that correspond with Month = 1 AND Year = 2018. This would then populate the 2017 and 2018 columns by Month on the other sheet. Any ideas would be…