Featured Communities

    Forum Stats

  • 58,305 Members
  • 36,772 Discussions
  • 138,809 Comments

Recent Discussions

Join the Smartsheet Community

Find answers to Smartsheet questions, learn about project management best practices, discuss the future of work management, and get how-to guidance for every Smartsheet use-case from fellow users and Smartsheet experts.
View All 

Discussion List

  • 5 columns in Sheet 2 Compared to Sheet 1
    In Formulas and Functions
    This discussion was created from comments split from: Find Difference between two Cells that could be Multiselect Dropdowns or Text.
    Answered - Pending Review
    11 4
    Answered - Pending Review 11 views 4 comments Most recent by Paul Newcome Formulas and Functions
  • "Not Equal To" Help
    In Formulas and Functions
    I have the below formula that works with the exception of the OR function. It is not omitting blank cells or cells that contain "Vacant" in the Emp No in its count. =COUNTIFS({Route}, $[Primary Column]@row, {Landside Storm helper…
    Answered - Pending Review
    12 1
    Answered - Pending Review 12 views 1 comment Most recent by Genevieve P. Formulas and Functions
  • Day based Reminder Workflow
    In Using Smartsheet
    Hi there ; i need your supports to create a workflow for below issue : i have a date type column named " remind date " , i want to create a send alert workflow.This workflow will start to work after 3 days later from "re…
    Answered - Pending Review
    6 1
    Answered - Pending Review 6 views 1 comment Most recent by BullandKhmer Using Smartsheet
  • How to Rank item value ignoring empty or blank cells?
    In Formulas and Functions
    Hello. need help on this. I'm trying to rank the item name based on value % (highest to lowest). When one item name has no value % it gives a #NO MATCH on that item row and on the succeeding rows/item. Please see screenshot (sample). Th…
    Answered - Pending Review
    24 3
    Answered - Pending Review 24 views 3 comments Most recent by Genevieve P. Formulas and Functions
  • Can I re-set baseline if baseline columns are used in formulas or conditional formatting rules
    In Using Smartsheet
    I have a conditional formatting to color code status cell based on risk level of the task (on schedule, behind or begin scheduled but not started). That works if I use start and date columns as planned and never change while tracking of …
    Answered - Pending Review
    16 1
    Answered - Pending Review 16 views 1 comment Most recent by Genevieve P. Using Smartsheet
  • Can i delete dynamic views created by a now deleted licenced user
    In Apps, Integrations, and Add Ons
    I have a licenced user who's profile was deleted but there remains several dynamic views that seem not to have been cleared out that still show in my profile as shared by owner of "deleted profile" - can i remove them? or do i ha…
    Answered - Pending Review
    9 2
    Answered - Pending Review 9 views 2 comments Most recent by Andrew Sellars Apps, Integrations, and Add Ons
  • Parent = "complete" when all children are
    In Formulas and Functions
    I want a parent cell to register as "complete" when all children have been marked as "complete". I've tried a few things but none are working. Any help would be great!
    Accepted
    13 4
    Accepted Answer 13 views 4 comments Most recent by gregorc3 Formulas and Functions
  • List of reports using a column of a sheet
    In Using Smartsheet
    Is there any way to find out the list of reports using a particular column of a sheet? I want to change the name and column property of a column. However, I would like to know the impact of this change on the multitude of reports that I h…
    Answered - Pending Review
    14 1
    Answered - Pending Review 14 views 1 comment Most recent by Genevieve P. Using Smartsheet
  • Help with a Currency Conversion
    In Using Smartsheet
    Hi there, wondering if anyone can assist.... I am looking for a way to take various native currency amounts in say 2 separate columns (i.e. USD and EUR) - when I enter a respective amount a formula automatically takes that value, changes i…
    Accepted
    11 7
    Accepted Answer 11 views 7 comments Most recent by Andrée Starå Using Smartsheet
  • I cannot copy data across sheets
    In Using Smartsheet
    Hello, I am trying to copy rows from one sheet to another. Everyday, because smartsheet cannot upload excel data directly into an existing smartsheet, I upload the data into a new sheet and copy the data across into a sheet which has a da…
    Answered - Pending Review
    16 2
    Answered - Pending Review 16 views 2 comments Most recent by crischadikun Using Smartsheet
View All