-
What network ports are used for uploading file attachments in Smartsheet
I want to be able to block the network ports in my firewall to prevent a user from being able to attach a file to smartsheet. If not ports, then what is it connecting to on the other side and I can block that. I have the Team plan, and unlike the Enterprise plan, does not give me the control to restrict/block that…
-
Ticket Tracker Notifications
We would like to have Ticket Tracker send an email to the person who submitted the ticket to us, when that ticket has been "resolved". I do not want everyone to get the notice, only this one person. Has anyone been able to do this? I can set the Alerts but cannot narrow it down to just the one person. I can do a reminder,…
-
Milestones centered on the day
Rightnow the milestones are represented by a diamond in between two days. (not actually centered, but no doubt it's a milestone on a friday). Is there a way to choose how the diamond milestone is placed? It would be a great enhancement to be able to choose in the settings how milestones are placed. Almost every other Gantt…
-
Setting up a Point of sale Sheet
Good afternoon, I was thinking of setting up a POS/point of sale sheet on excel. I googled it and found instructions on how to do it. But the person that was nice enough to post the information wrote it assuming that everyone knows how to enter Macros etc.. Then it came to mind that I should check here. I did speak with…
-
Access Control - option to share to anyone with link is not available
When I click 'Publish,' the option to share with anyone is greyed out. I'm the owner of the smartsheet and need to make it viewable (in read-only) to anyone with the link. How can I do this? Also, Full HTML is the only option I'm given - the other two are greyed out. Thanks in advance.
-
Date Driven row roll off
We keep a list of Completed tasks. Based on the date in the Work_Ended column, I would like to autmomatically move rows > 90 days old onto another sheet, which we'll call Completed Archive. Is there any way to automate this process? Thank you!
-
Assigning Team Memebers to Task/Duration
Let say you have a task with a set duration, start and end date. The duration was based on 1 person doing the work but if I want to assign it to 4 people so it theoretically goes 4 times faster. Is there a way to say to smartsheet "This task has 4 people working on it" and for smartsheet to then adjust the duration, start…
-
Extract top risks from risk log for highlight reporting
Hi there I'm running a risk and issues log and need to pull out my top 5 risks and issues into a monthly highlight report. These are based on the original risk score and the score post mitigation(s). Within my highlight report I have a number of cell links which pull through parts of the project plan but because the risks…
-
How to populate % Complete from another Text/Number column that has a formula
Hi, I'm trying to calculate and populate % Complete automatically using check boxes fields. For example I have 3 check boxes for 3 main activities per record. So I created I new field Count Check Text/Number field where I check if the first check box is checked the new count is 33%, if the second is checked with the first…
-
Helpful if Date format has letters in it
Hi, I am working on a project wherein a part of the development team in India and other part in the US. I initially had my Language (Country) setting as "English (India)", but this date format caused confusion for the team which are in the US, since it is based on dd/mm/yy whereas the US is used to mm/dd/yy. For example,…
