-
Resource View per task (Portfolio Management)
Hello, I have a Smartsheet template containing a list of all projects in my portfolio. Each project takes one row, and in this row I have assigned PMs per project (up to three) including their allocations as percentage. When I go to the Resource View, I see the allocation per PM and when clicking in their names I see the…
-
Switching from licensed user to regular collaborator
We have a licensed user who no longer needs this level of access, so I want to switch her to the regular collaborator. If I do this will this effect any of her sheets that she created until the license user level? Or will she retain all of these and then just be limited as she moves forward? Thanks
-
Timestamp for changes in each row
Hello, I created a "Modified" column in smartsheet to track changes for each change within that row. It appears to be constantly changing in the entire COLUMN whenever any thing is changed in the sheet. This is a major problem since my formulas are referring to the cell that has the last change mod done to it. Is there a…
-
File links uploaded into Google form are garbled in Smartsheet
I have an existing Google form and one of the options is to attach files. When the form is submitted, the values I'm getting in Smartsheet are garbled, something like: "0B6fDccPdKcYeY0tlcjJnVTlMYWM,0B6fDccPdKcYeQi1Malg1YXVDMmM,0B6fDccPdKcYeZkIxVURBU3hjbWc" This column is supposed to be populated with Google Drive links.…
-
How to Trigger Formatting from Comparison / Nested IF?
Hello! I have project sheet, with dependencies enabled. This requires manually updating the % Complete value. I would like to add conditional formatting to remind myself to update the % Complete. IF [Completed]1 is not blank and IF [% Complete]1 does not equal 100% Then Format [% Complete]1 Cell Fill Yellow (screenshot…
-
Update Request that uses cell color
Good Morning, I am using Smartsheet to track students that are Below Grade Level, On Grade Level and Above Grade Level. The cell color for Below Grade Level is red, On grade level is light green and Above Grade level is dark green. When sending an update request for certain rows to one of my teachers, the colors in the…
-
Smartsheet Team Plan Offline and No Response from Support
Last week we cancelled a recurring PayPal payment approval on the PayPal site, so that we could register a different card as our preferred SmartSheet payment method for our annual plan. Although we didn't make any changes on the Smartsheet website itself, our Team Plan instantly disappeared and all Users were downgraded to…
-
Is there a formula for averaging the remaining?
Hello again! I have been trying to figure out a formula for averaging the remaining. This sheet has all business days through Dec 8 and a certain number of tasks to complete each day to be finished on time (Dec. 8). There are two columns. One has the number of tasks due to be completed each day (labeled Average) and the…
-
Background and Font Color Default
I would like the ability to set the default color for the background and font to colors that I use on a regular basis. I have already submitted this enhancement request to Smartsheet but I was wondering if anyone in the Community thinks this would be useful.
-
Preventing Modified by and Modified when rows have formulas
Hello! All my sheets have automation (formulas). I am having difficulties keeping track of who has modified records. We do not have access to sheet history because we are on the Team Plan only. This is a huge problem because we have issues with managers not updating project status on a timely basis. I have no recourse.…
