Sheets
Discussion List
-
Imported Formulas from ExcelIn Formulas and FunctionsHappy Wednesday! I have been going in circles trying to figure out where this formula is going unparseable. I researched it against other similar (working) formulas in smartsheet and the Formula errors guidance- but I am still missing it…Answered - Pending Review 12 views 5 comments 0 points Most recent by Cat Werbeck Formulas and Functions
-
Gathering data from 1000 sheetsIn Using SmartsheetHello, i have this question: We have more then 1000 sheets with some project progress calculated in certain cell. Then we have one master tracking sheet with 1 line = 1 project. What i need is: Link this progress number from each sheet to …
-
Tracking date when a drop down value is selectedIn Formulas and FunctionsI'm creating a project tracker where I can assign what phase the project is at (design, prototype and complete). What I want to do is track how long the project is in each phase, so what I plan on doing is tracking when the drop down items…Answered - Pending Review 13 views 2 comments 0 points Most recent by Cole Fuerste Formulas and Functions
-
Pasting Data SetIn Formulas and FunctionsHi, I have a large data set that I paste into Smartsheet from excel for a Dashboard to populate. When I paste some of the data in that's in 1 cell in excel Smartsheet is splitting it across multiple columns meaning I manually have to amen…Answered - Pending Review 2 views 4 comments 0 points Most recent by Maxine Roberts Formulas and Functions
-
Is there any way to select only specific columns to be included in alert messages that are sent outIn Using SmartsheetIs there any way to select only specific columns to be included in alert messages that are sent out using the SmartSheet Automation feature? Currently, I set up an alert. And it displays all of the columns, even if I hide certain columns …
-
Index/MatchIn Formulas and FunctionsI have a smartsheet that has a column for "State" and then a column for "Territory". How do I write a function that if a row within column "State" equals say "TX" than the column for "Territory&…Answered - Pending Review 12 views 3 comments 0 points Most recent by Andrée Starå Formulas and Functions
-
Can you use Groups in Contact list column type?In Using SmartsheetWe have different groups created under user management, for example, email team, marketing team etc. I wanted to know if they can be used inside a column with contact list column type for a project? If yes, how? If not, what exactly is the…
-
Can I combine multiple rows into one row on a Gantt Chart?In Using SmartsheetDear all, I want to aggregate multiple project schedules into a master schedule. When copying the milestones from various projects into a single sheet, my overall Gantt Chart displays an event as a row, and each project occupies many rows.…
-
Lock or Store Date/Value Solution without using ZapierIn Formulas and FunctionsHi all, I hope you're well and safe! I've developed a solution that lets you store the date or value. You'd use the copy-row automation and a VLOOKUP or combination of INDEX/MATCH to make it work. We'd trigger the copy-row to another sh…
