-
Editing the Layout in Dashboards
I've created several dashboards where the content/widgets are not static. I'm frustrated by the tedious way I have to move widgets around on the page. I would love it if there was a way to "group" several widgets so moving them around could be easier. Or maybe be able to create a "corral" of sorts, so that items could be…
-
Nest an IF Formula
With the help of the community, I have two formulas that I would like to combine into one if possible. Formula 1 =IF(Ancestors@row = 0, COUNTIF(Ancestors$1:Ancestors@row, Ancestors@row = 0), "") Formula 2 =IF(LEN(RowID@row) = 1, "000" + RowID@row, IF(LEN(RowID@row) = 2, "00" + RowID@row, IF(LEN(RowID@row) = 3, "0"…
-
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",…