-
User Acceptance Test Script Template
Has anyone created a user acceptance test script in Smartsheet before? If so would you be willing to share the template with me?
-
Automatically Generate Decision Log from Action Item List
I’m looking for guidance on how I would (or if it’s possible to) automatically generate line items on a decision log from an action item log column value (separate sheets). What I mean is, whenever the value of “move to decision log” is selected from the next steps column in the action item log I would like for a line item…
-
Formula does not always recognize "" for blanks?
I have an odd one that hopefully someone can shed light on as i am going a bit crazy :) I finally figured out a formula i have been working on for few days ... strangest thing it seems to have been the quotes that i was using ??.... I used the quotes (directly to the left of the enter key with shift ) as a blank and i…
-
Satisfy all requirements; with different formats of columns
Hello :) I need some help :) i think i have a few steps i will need to complete .. however big idea is to be able to make sure multiple columns have criteria matched; then send a notification with an attachment as well as mark a checkbox complete .. initially i think i need to use a countifs formula to tally all columns…
-
Reporting and dashboard help
I have a smartsheet containing work experience for every person in our company. The rows go something like this... * Steve Smith | Project Manager | Company A | 2.5 years | etc... * Steve Smith | Project Manager | Company B | 1.5 years | etc... * Steve Smith | Project Coordinator | Company B | 5 years | etc... * Karen…
-
Notification within smartsheet is not working
Hello, I don't receive any notification when other users made a changes! any ideas?
-
Labs- Smartsheet Charts
Hi, I have created a few charts on smartsheets labs, i am however getting this error on certain columns: All series on a given axis must be of the same data type These columns are the only ones to have negative values (-30 etc). So my first question is does the smartlabs charts allow negative values. My second question is…
-
Best "infrastructure" columns for portfolio reporting
I am wondering if someone has some advice on the best infrastructure columns to add to project sheets to enable formatting, portfolio rollups, metrics, etc. I current have automated checkbox hidden columns for parent, child, ancestors, milestones, status (based on due date). What other hidden columns do people include in…
-
Ranking Rows based on values in specific column
I would like to formulate a ranking system in a column that will base the rank on an existing column. Are there any functions that can do this?
-
Independent work days for tasks or resources?
I have holidays blocked out in my calendar, however there are certain tasks/resources where the holidays don't apply. For instance, China is closed for all of February for Chinese New Year and I have those dates blacked out, but I don't want them to apply for folks in USA who will still be working. Is there a way to either…
