-
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",…
-
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
-
Can you create a Sheet Rollup of all open actions from each project owners sheets?
What about a sheet to roll up all open tasks of each project owners sheets so a managed worked flow to request updates would include all updates needed for all the project owners sheet actions? This way they are not getting a lot of separate emails for updates on each sheet.
-
How to create formula to count over the past seven days
Hello, I'm trying to count the number of projects delivered in the past seven days. This is what I have so far: =COUNTIFS(Status:Status; "Delivered";Delivery Date:Delivery Date; >=TODAY(-7)) I'm not sure what's going wrong or where to insert the formula in the sheet (will any cell do?). Thanks, Emily
-
Sum all Rows
My sheet has 3 columns (Team, Activity, Amount). I have a summary section at the top of my sheet where I want to use a SUMIF function to total up the amount for each Team. Generally, I can get the SUMIF function to work just fine. But, I run into an issue when adding new rows. The function looks like this:…
