-
Extract top risks from risk log for highlight reporting
Hi there I'm running a risk and issues log and need to pull out my top 5 risks and issues into a monthly highlight report. These are based on the original risk score and the score post mitigation(s). Within my highlight report I have a number of cell links which pull through parts of the project plan but because the risks…
-
Zapier and duplicates
Hi all, I'm hoping to tap into collective wisdom to sort out my problem. I'm trying out Zapier to do the following: if a row is updated with a date in the future, copy it to another sheet, only once. If the date gets updated again, I don't need to create a second copy. I created a Zap which works well, except it copies the…
-
How to populate % Complete from another Text/Number column that has a formula
Hi, I'm trying to calculate and populate % Complete automatically using check boxes fields. For example I have 3 check boxes for 3 main activities per record. So I created I new field Count Check Text/Number field where I check if the first check box is checked the new count is 33%, if the second is checked with the first…
-
Is it possible to "change ownership" of a workspace, not just a sheet in the workspace?
I have tons of Workspaces for different projects but after I've wrapped up the project documentation, sometimes the WS will live on for "user group" initiatives. I would now like to pass the torch and make someone else the owner of an entire workspace to manage the future roadmap of a system but don't see options to do…
-
Given two columns A&B, what formula would I use to pull a value from B that corresponds to the MAX(A
Given two columns A&B, what formula would I use to pull a value from B that corresponds to the MAX(A)?
-
Colouring Cells using a formula.
Hi, I am trying to colour cells depending on the data in cells to show a status. below is the statement so far but cant get it to work correctly. any help would be great. =IF(AND(TODAY() > Start166, [% Complete]166 = 0), "RED", IF(AND(TODAY() > Finish166, [% Complete]166 > 100), "RED", IF(TODAY() < Start166, "WHITE",…
-
Creating a group that includes everyone in my Enterprise Account
Is there a way to populate a group with everyone in my Enterprise Plan automatically? So every new user is added to group seemlessly? I would like to use this to be able to share sheets or workspaces with everyone in my company. Thanks for helping!
-
Can you import Google Analytics Data to Smartsheet?
We need to get GA data in SS for multiple websites to run reports, We were wondering if there was a way to connect with GA like some of the visualization companies do.
-
Formula to reference cell in another sheet?
Hi, I'm wondering if it's possible to reference a cell in a different sheet with a formula. My source sheet is intended for users to add entries, and my destination sheet is intended to keep track of when the source sheet was last updated. Because entries are added to the source sheet, and I always want the newest date on…
-
Test for auto-follow discussion (Firefox)
Second test for https://community.smartsheet.com/discussion/new-discussion-does-not-auto-follow Firefox Firefox text for screen shot https://community.smartsheet.com/discussion/new-discussion-does-not-auto-follow