-
Looking for some guidance: need recommendation on the best template to use with client to track feed
Hi to all and thanks for considering my request. We're somewhat new to SS, have looked at all templates without finding a product evaluation feedback form that would allow users to share issues, insight, feature requests and help requests for a 30 day product evaluation period. I'm not expecting to find the EXACT template,…
-
SUMIF IF referred sheet/column ISDATE
Hey everyone, working on something that i am having a problem with I have the following =SUMIF({FSM - Help Desk Ticket Tracker Range 4}, $VlookupValue@row, {FSM - Help Desk Ticket Tracker Range 1}) This returns the value from the cell that i want to perform a specific calculation. I want to add more to this though. The…
-
Risk Assessment
Hi All has anyone successfully made a risk assessment template within smartsheet ? Im not able to get normal excel formulae to work ( also the templates posted on smartsheet dont work ) appreciate if you could share template with me :D Marie
-
Alarms with conditionals
Is it possible to set up an alarm/reminder with conditionals? For example: I need to send an update request to certain contacts that show in a column that the task is due on a specific date. Thank you
-
Undo question
Hello, I was editing a formula and somehow the whole sheet appeared with the error #INVALID OPERATION. I was trying to undo the last change to reverse it, but the button wouldn't appear enable and the sheet was saved! I invested a lot of time ==(. Is there anyway to recover the previous version of my sheet? Thank you.
-
Stale time/date
Hi, I am trying to setup a "Stale" notification for a help ticketing system. When a support ticket (row) ticket has not been modified when compared to the current time and date in over an X amount of hours, then send a notification. I can compare two different date columns like this: =Modified1 - [Created Date]1 But if I…
-
Alerts not going every time and to all addresses?
I have many (20) alerts setup on a support queue sheet. Some of those alerts need to go to multiple people. I've set the alert up correctly to send to up to three recipients. I am one of those recipients. I know the alert triggers because I received the email alert, but the other two did not. I've also seen where one of…
-
Auto-fill based on Column value
I have a drop down box containing staff member names, when selected I want it displayed automatically in the "Assigned to" column our company name. I have searched help but so far no luck, can someone assist? cheers.
-
Restrict to login by ip address
Has Smartsheet got any functions to block by public ip address except single IP? My wish is to use only our local network in our office.
-
Report Not Updating
What’s the deal with reports not updating. It’s been 2 days now. This is a constant issue. Is anyone else having this problem, again?
