-
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…
-
Accidentally unsubscribed from notification in a row, how do I get the notifications turned back on?
I was scrolling through a notification email and accidentally clicked on "unsubscribe from notifications". It did so immediately instead of asking if I was sure I wanted to unsubscribe (like most other programs do). I don't know how to subscribe again, it is on a row that I have a task assigned so I need to be able to see…
-
remove column ids, row ids from Smartsheet json!
hi team, I need help with removing the overheard data from the Smartsheet api call that returns a json file, I need to remove all the overhead before putting the data into the pipelines, thanks.
-
Collaborators
We currently have a team account and it appears when I add collaborators to the sheets, when they accept the smartsheet and setup in smartsheet with a "free trial" I then get calls from them that their free trial is expiring, In addition, under their free trial they are able to move columns and edit the sheet, which they…