- Extracting all instances of a word from a text string and creating a list in a separate cell
Hello all, I have been pouring through excel and smartsheet help forums for a couple of days now, and I haven't seen my issue asked or addressed so thought I'd ask here. I have, in one column called Terms, cells that contains lists of terms and phrases. For example, one cell contains the following text string:…
- Timelines
你好社区!是there a way to make a timeline in days instead of in dates? Like total timeline of 2 weeks as opposed to 1/1/19-1/14/19? Please help me out!
- Use triggers from Smartsheet?
Working on a new workflow. Today's workflow is manual and based on emails. I'd like to use the webform to collect the required data (done) and then, based on specific conditions in the sheet fields trigger actions in other system - from generating email to open a service ticket etc. I watched the movie of the docusign -…
- Parent row based on children status and due date formula
Hello, I have a sheet that tracks event deliverables for 150 or so events each year. The way the sheet is set up each parent row is the event name, and then the children rows are each task for that event. I have a column for Status with the options for Complete, Not Started, and In Progress. I want to create a new column…
- Select SmartSheet Alerts not sending
Hi there, I am setting up 3 alerts for a sheet: 1) When a new row is added (via a Form) 2) When an "Approved" column is checked 3) When a "Done" column is checked The first alert sends an email. However, I am having trouble with the last 2. Email alerts are not being sent for some reason. For testing purposes, I currently…
- Counting RYG Balls
Hi guys, Is it possible to count the number of balls according to their respective colors? Many thanks in Advance.
- 是there a way to collapse the rows in a Gantt chart?
I'm trying to take a spreadsheet and present it in a way that has one row for each category of item, and then multiple cells across that row to represent the emails sent in that category. This is a calendar of sorts. Each category would be associated with a color. (That's the part I have figured out.) I saw Smartsheet's…
- Linking Sheets
I am working on a master SmartSheet to roll up other Sheets into one. When changes are made in the linked SmartSheets, this is not reflected in the master. If I add additional rows, my master is not updated What I am missing?
- Identifying and returning phrases within a single cell
Hi all, I have been trying to figure it out alone but I thought I'd engage the community to see if anyone can help! I have a column in my spreadsheet that contains phrases separated by commas - for example (though with different words), in one cell it says "Phone, computer, mouse, cell phone, water bottle, earphones, bag."…
- Web Form - compare two columns - ie validate a email entry
Dear Community: I am using Smartsheet to allow my customers to enter their own account information....which all rests on having a valid email address..... I have looked but can not find a SS solution to asking for a email address and then asking for it again....compare the two entries ....and either accept is they match…
