Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please
Visit the Current Forums.
Discussion List
Automating RYG And CHILDREN Formula
Hi I am looking for a formula that will show in the parent an RYG colour based on the children. If there are any Red in the children, I want to show Red in the parent, If there are no Red but there are Yellow in the children, Show Yellow in the parent. If there are no Red or Yellow but there is Green in the children, Show…
If statement for checkboxes
Hey everyone, I have project schedules with milestones that have associated tasks for each. (i.e. releasing a drawing set includes getting it stamped, sending to subcontractors, etc). I would like to make the tasks a checklist that would populate the percent complete (instead of a harvey ball), using a formula. Has anyone…
URGENT HELP - Remote sign out
HELP!!!!!!!! I have just left a customers premises and think i may have left my smartsheet open. HOw do I log out remotely.
WorkSpace - Sharing
In Workspaces - Can you share a folder with specific people that are not included in an overall workspace? (For Example - we have a workspace that is shared internally with client folders, but would like to share a specific folder inside those folders with clients. But not allow them to see the whole workspace.) Currently…
Interconnecting sheets/data?
We are evaluating Smartsheet as a Project Management solution. I'm wondering if it's possible to have a sheet for "Client Contact List" and then a "Project Management" sheet that can reference it. For instance, could I create a column called "Contact" and select from my contacts and have it auto-populate other columns such…
Sorting by "start date", sorting by "assigned to"
Does anyone have recommendations for how to sort a master sheet by "start date", so that the dates are in ascending in chronological order, and also how to sort by "assigned to".
How do you archive Sheets without deleting them?
Hi, I was hoping that I could get some information on how I archive sheets?
Feature Request: Preserve Formatting During an Import
When importing a file into SmartSheet, it would be extremely helpful to have a "Preserve Formatting" option. This will save the user much time in having to make the sheet look visually similar to its excel (etc) counterpart. This will also keep hidden rows/columns hidden, fonts and colors preserved.
Anyway to have parent automatically get checkmark?
I have a parent row with 5 children rows. Is it possible to set my sheet up to have the parent row automatically get the checkmark after all the children rows have been checked off? Example: Is there anyway to have Project A auto check since objectives 1-5 are completed?
NEW - Dashboard + Card layout
Is Smartsheet getting ready to release the new dashboard and card layout/view? Looks like they are close. There are a few screenshots within the video and webpage. https://www.facebook.com/smartsheet/videos/10153492657651379/ https://www.smartsheet.com/enterprise/scale These look amazing but I still cannot wait to get…
