Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please
Visit the Current Forums. Discussion List
Formulas are not copying to new entries for forms.
Every now and then, new form entries in my sheet will have some or all formulas missing. I add all new entries at the top of my sheets, so there are never any "blank" rows between that and the one below. I have an integration solution set up keying off of some of these formulas, so whenever they fail to copy, that gives meā¦
Unsubscribe from email alerts
Does anyone know what actually happens if a user selects the unsubscribe option when they receive an email alert? Many of our alerts are not necessarily optional I don't want users to be able to just opt out of them at will. I selected this on one myself to see what happens, but I can't find anywhere on my sheets or theā¦
Is there a way to re-designate the primary column after a Smartsheet has been developed and populate
I would like to switch the information that is displayed in the calendar view to data that is present in another column within my sheet.
how open a link from a Hyperlink cell
Dear all I've crated some hyperlink to local directories, I'd like to be able to open link when I clic on them (Only cell edition is available, to change the value) Thx
Control Center
Hi, does anyone use SmartSheet Control Center solution? I have not been able to find anything on it outside of SmartSheet marketing. Thanks
I need both dependencies and predecessors
I have used the predecessor column and love it but I need to also have a dependency column. For instance if I have task 1, 2, and 3 and 3 has a predecessor of 2 and 2 has a predecessor of 1 then I want to know that 2 has a dependencyĀ of 3. Knowing the predecessor only tells me what needs to be completed before the task. Iā¦
locking a formula
i have to organise a list of passengers on a mini-bus. Row 6 contains a list of those passengers, with the first column after the primary column containing a count function telling me what the total number of passengers there are in row 6. Row 7 is blank and if a passenger is not going to be on the minibus i drag them downā¦
Hyperlinks Are Lost When a Sheet is Exported
When I export any of my smartsheets where there is a hyperlink connected to text within a cell, the link is lost. It doesn't matter if it's an excel sheet, google sheet, or PDF, the links are lost and have to be reconnected from scratch. Is there a work around for this?
Alerts not Sending to Assigned To Column
I want to send a daily reminder listing open tasks to contacts listed in my Assigned To column. All contacts have been shared to the sheet as Editor - cannot share.Ā At least a couple of these contacts are users who have used SmartSheet before. I set a conditional formula in a reminder date field to populate with today'sā¦
Counting "At Risk" Flags
Hi, I am trying to use COUNTIF for counting number of projects with "At Risk" flags turned on. I get #UNPARSEABLE for this- COUNTIF(At Risk:At Risk, 1). Any feedback appreciated. Thank you.Ā