-
Contact Formatted Cell --> Autopopulate Info into another cell.
How can I get a cell that is formatted as a Contact List to populate a cell to the right with a phone number, email, or other static attribute when a select different contacts? Our assigned to items can change quite frequently, and it would be great to autocomplete contact info in the next cell automatically. Thanks.
-
Auto change status to complete based on start/finish date?
Hello, I've looked through the forums but can't seem to find a formula that works. My columns are status (Not Started, In Progress, Completed, and ERROR). I need the status column to reflect what is input into the start/finish date ex: start date today end date blank = In Progress. I also want to display an ERROR message…
-
Transferring ownership
Hello! I am an admin at workspace of the company. I can't take ownership of sheets from an existing user with business license. I have this message when trying to get ownership: You cannot take ownership of this item because the current user is not in your organization. Can you please help to solve this problem?
-
Nested IF with CONTAINS
Hello, can anyone help me why this formula doesn't work? =IF(CONTAINS("Red",Issue1),"Red"),IF(CONTAINS("Green",Issue1),"Green"),IF(CONTAINS("Yellow",Issue1),"Yellow",)
-
Can you create a master project plan with rollup plans below?
I need to create multiple project plans with one resource in common so I want to make tasks between the plans dependent on eachother so that the engineer doesn't have overlapping work and if one task is delayed it will impact the other projects. Is this possible? I don't want to run a report because I won't be able to add…
-
Web Form not populating data on sheet
I have created a web form that populates the data onto a sheet. Its similar to a web form and sheet I have already created. I have tested with a few users and the data comes through fine. 2 other users have submitted a web form but the info is not populating. I have the feature set where all new entries populate on the top…
-
Workspace "cover page"
Would anyone find it useful to have a cover page for Workspaces that, when the workspace is first opened (or every time it's opened), you see a rich text explanation of what that Workspace is for and how a person could or should interact with the sheets, reports, or dashboards inside? because I could find that useful. :)
-
Help to Simplify Logic
I'm creating a smartsheet with several columns and created a few formulas that I believe could be simplified to achieve the same result, but I can't seem to think of an easier way. Can you please try to help me out? HEALTH COLUMN =IF(OR(CONTAINS("Red", DESCENDANTS()), CONTAINS("Yellow", CHILDREN())), "Yellow",…
-
I have some questions about using smartsheet for managing sign ups for courses
The aim is micromanage / manually edit lists as little as possible. I would like to use automation for situations below: Is there a way to automatically stop/block the option for duplicate enrollments from the same person ( based on email address)? Set a default maximum limit for enrollments? ( stop registration option…
-
Build questions in a form based on rows, not columns
Is this possible? I have a checklist sheet, with multiple questions set out in each row. Id rather avoid making each question a column so would it be possible to create a form based on the questions in the first column for each row? Thanks, Jack