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.
Discussion List
-
5 columns in Sheet 2 Compared to Sheet 1In Formulas and FunctionsThis discussion was created from comments split from: Find Difference between two Cells that could be Multiselect Dropdowns or Text.Answered - Pending Review 11 views 4 comments 0 points Most recent by Paul Newcome Formulas and Functions
-
"Not Equal To" HelpIn Formulas and FunctionsI 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 views 1 comment 0 points Most recent by Genevieve P. Formulas and Functions
-
Day based Reminder WorkflowIn Using SmartsheetHi 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…
-
How to Rank item value ignoring empty or blank cells?In Formulas and FunctionsHello. 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 views 3 comments 0 points Most recent by Genevieve P. Formulas and Functions
-
Can I re-set baseline if baseline columns are used in formulas or conditional formatting rulesIn Using SmartsheetI 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 …
-
Can i delete dynamic views created by a now deleted licenced userIn Apps, Integrations, and Add OnsI 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 views 2 comments 0 points Most recent by Andrew Sellars Apps, Integrations, and Add Ons
-
Parent = "complete" when all children areIn Formulas and FunctionsI 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!
-
List of reports using a column of a sheetIn Using SmartsheetIs 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…
-
Help with a Currency ConversionIn Using SmartsheetHi 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…
-
I cannot copy data across sheetsIn Using SmartsheetHello, 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…
