I'd like to try and figure out how to most effectively and efficiently connect 2 separate smartsheets together, preferably through some sort of smart formula/code. I don't think doing a manual "cell linking" from a cell in one sheet to the next would be very smart or efficient for what I'm trying to do here. I have both a…
I am modifying the "Help Desk Ticket Tracker & Form" template. I don't want to double-enter the date, so I deleted the 'date' column and am using the 'Created (date)' system-generated column. When I use the webform, it will fill in the date created. But if I add a line directly in the smartsheet, it leaves the Created date…
Is there a method to change column names in multiple sheets? (I'm aware of the impact on reports that include those sheets.) It is very labor-intensive to change the column names in multiple sheets, but that is how we work in the real world. Change, change, change. I've already updated the template, but wow what a pain to…
Shaine, I was able to preview the formula Help and Activity Log prior to the release. Really liking the Activity Log for a sheet we recently rolled out that has over 500 users updating it. I'll have to spend more time on the formulas to give feedback. I did notice that the Release…
Hi, I'm trying to figure out why some of my parent background are grey, and some are not. In the page: https://help.smartsheet.com/articles/504734-hierarchy-indenting-outdenting-rows about 1/2 way down, under "Expanding and collapsing.." both "Administration" and "software engineers" parent rows are grey background. But in…
I've set the auto-save to 3 min. of inactiity. But i get this prompt to save. Am I minstanding how this feature work?
Hello! I would like to track the 'Created by' field on my web forms. In order to do that it requires that the "Accessible by" option the web form be set to 'A Registered Smartsheet user (requires login)' be selected. Can that user be a registered user but not a licensed user? Thank you!
I am using the Event Registration template with Web Form template to register people for a number of volunteer events. I am using a SUMIF formula to count the number of people registered for each event. My problem is this: When I use a range of cells to indicate which cells should be counted, the Web Form puts the next…
s it possible to create a formula or a conditional formatting rule that would automatically highlight any child rows as they are created and/or based on a specific term or text in a column of the parent row?
I was updating my sheet yesterday and payed no attention but this morning I've noticed that all of the task names on the Gantt chart are gone and I can't seem to find a way to get them back. Any ideas? Thank you in advance!
