-
Mapping data within a hierarchy
Hello, I hope you are well. I'm trying to find a way to collect information within a hierarchy on a sheet. I need to gather the last date for a column within a level of the hierarchy and display this date in the parent cell of this hierarchy, regardless of whether new rows are added during the project's development. The…
-
Formula to count of items in a multi dropdown list
Hi The drop-down multi select is very nice and useful. I started to use it yesterday, but I need to use the formula =countif(range, criterion). I want to count how many times a value is repeated in a range that has multi values. I use the formula countif and only count one time a repeated value when the cell have multiple…
-
Vote for Smartsheet Community in the CMX Awards! ⭐️
Community, time to rock the vote! We are so thrilled to announce that we have been nominated for a 2024 CMX Community Industry Award in the Customer Support Community category. These awards celebrate and recognize the achievements of both people and teams in the community industry - an industry that is all about bringing…
-
Merged: DataShuttle Workflow Errors (Action:Replace)
This discussion has been merged.
-
link between sheets
Hi! I'm working with two different sheets. The first one has all marketing activities (webinars, events, trade show, etc). The second one has all the marketing assets created (Ebook, social media cards, etc). I would like to link which assets can be used for which marketing activities. A marketing activity can use more…
-
OneNote integration in Smartsheet
Based on a suggestion I read on this board, I am posting a product enhancement request I just submitted for the community to see. Request OneNote integration in Smartsheet to easily paste in a link to a OneNote page/paragraph/section/section group in one click, and then designate whether to open in the OneNote desktop…
-
Count value from Row
Hello Team, I need your help to count value form row. Here is my question. So I want to count all C0 in my whole spool numbers. I tried formula =COUNTIF([Spool Number]1:[Spool Number]926 @row, CONTAINS("C0",@cell)) Please correct me where I am wrong. Thank you.
-
Basic copy/paste function
I don't understand why the simple copy/paste function of Smartsheet doesn't seem to work without going into a cell. For example, if you're trying to copy a number of cells (name, email address, request ID) to be used either in Smartsheet or notepad, you'll get the functionality via Cntl+c or right click ->copy. The data…
-
Clone Workspace with link
Hello, I was going through the Smartsheet Academy and saw a page where SS displayed a link and if you select it, it would automatically clone a work space for you without having to manually clone. I'm currently making a dashboard depository of our workspaces we would like all employees to use as templates for projects to…
-
November Question of the Month 💭 Join the conversation and receive a badge
Hi everyone, In the October question we asked you to share something that scared you until you tried it, and you inspired us with your stories of courage. From career changes, and parenthood, to solo traveling, and jumping into a cenote — You’re incredible! Now it’s time for a new question & opportunity to earn badges and…
