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 …
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 i…
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 w…
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 s…
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 SUM…
Hi, When copying a sheet summary to other sheets within the same workspace, it carries the field names but not always the information within the field. For example, after having copied the sheet Summa…
I am attempting to write a formula based on 2 separate criteria, though I feel like I need some type of "BUT" statement and could use some help. I want a picklist column to read YES or NO depending on…
I am an admin working on cleaning up our structure within Smartsheet to utilize workspaces and folders more. Will the link for a form that is shared across many users change if I move the sheet to a w…
I am trying to develop a formula to flag tasks that are less than 50% complete but more than 50% of the duration has passed. I'm not sure if my math is correct. But aside from that, can Smartsheet per…
Hi, I'm looking for some help on how to eliminate some risk when team members leave the company. They are deleted as a user and sheets transferred, however these said users after they have been delete…