-
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:…
-
Sheet Summary
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 Summary, the "Completion %" shows =[% Complete]30 + " %" or #UNPARSEABLE, instead of an actual number, ie. 50 %. There's no…
-
IF formula with multiple criteria
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 the following: IF Ins Status = Current OR N/A AND Agreement EXE is checked THEN Approved for Work = YES, BUT, IF Agreement…
-
Does the link for a form change if the sheet is moved?
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 workspace?
-
Formula for percentage complete and duration remaining
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 perform functions like the one I am proposing below? Currently, it returns an unparseable error. If I get this formula to work,…
-
Deleted user still able to access Smartsheet
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 deleted are still able to access into Smartsheet when they log on with a password but not single sign on. Once logged on they…
-
How to view a calendar by column other than the primary
Hello Smartsheet Community, I am trying to find a work around to view a calendar by more than just the info in the primary column. I currently have a sheet that contains all of our workshop orders for a particular product range. It contains the customer name, product type, dispatch date, ect. We look at this sheet in…
