-
Rostering for Global Customer Support
Hi, I have been asked to create a roster that covers customer support across different time zones and shows who is available (human resources), who is on leave, time, names of the support person and who is on call. Also, includes our contractual obligations with customers in an easy display view to the eye. Do you think…
-
Seeing user activity as an admin
I am an Admin of our account and want to see what smartsheets are owned by each user and the activity on each sheet (date/time). Logs only shows me logons. I need to verify that licensed users are really using the product. I put a ticket into support a week ago but never heard back. Hopefully I can get a response here.…
-
Links are not working from published reports
Nov 20th the ability to click on links in reports stopped working! I have submitted tickets and not a single reply or any help of any kind! Example = https://goo.gl/maps/cX1j23VBCMX1Zxde7 returns this: This site can’t be reached https’s server IP address could not be found. * Search Google for https goo maps…
-
Automated Workflows
I have been trying to create an automated workflow that triggers an email to the assigned to person when the Due Date field is not completed. I have tried different intervals, but it still isn't working. I have checked the permission settings and Personal settings. I appreciate any assistance.
-
Project Porfolio templates?
I am new to the community. I run a professional services organization and we use smartsheet for basic project management. I am interested in learning if Smartsheet has any Portfolio Management capabilities. Can anyone make a suggestion as to where to get started based on their experience using Smartsheet for Project…
-
Added information needed on Approval workflow
I have many forms - which are requests that need approval. When I create the approval workflow, it sends 2 buttons - Approve or Decline. I need more. I need a NOTES section for when it is denied so that the reason can be recorded on my sheet. I also need the name and date of the approval added to my sheet. The only thing I…
-
Reports not updating accurately from linked Smartsheets
Smartsheet appears to be a little slow today in updating charts, reports, etc. and with accurate data. Wondering if this is an anomaly or if this is due to a more global impact from Cyber Monday.
-
Doing two things in one IF statement
WHAT I'M TRYING TO DO: I would like to accomplish two things in one IF statement. Something like: =IF([This Column]@row = 1, [That Column]=true ALSO Today(), ....) WHY I'M TRYING TO DO THIS: I am trying to automate the Actual Finish column in my project management sheets such that, when % Complete reaches 100, then check a…
-
How to send automated birthday emails to employees in our company
Hello Team, I would like to know how to enable or create smartsheet to send automated birthday emails with customised template to employees in my org, on their birthdays. aprriciate for the help
-
Is There Really No Built-in Log\NL Function?
My team and I are trying to implement our escalation algorithm in smart sheet but it would seem that SS can't compute natural log in formula. Are we missing something; Why is the SS math library so dumbed down? Below is the formula in Excel we are trying to migrate. =ROUNDUP(LN(A2)/1.609437912,0)+1 WHERE: A2 is a user…
