-
Send email to people who fill out form at a later time
In trying to use Smart Sheet as a way to track applicants, and even use a form as an application, I'd like to be able to notify applicants that did NOT get the job that they didn't get the job. Is this even possible if I collect email addresses?
-
How Do I Prevent Spam Entries On My Web Form?
I see no option for Captcha or Honeypot to prevent SPAM bots from attacking my form, which is currently being bombarded by fake Chinese entries. How do I implement this?
-
customizing the email address for a request for approval
Has anyone played with the Request for Approval option? I'd like to be able to send this request to a client to approval work in progress. However, the email the client receives comes from "automation@smartsheet.com." I'd like to customize this so that it comes from me (like notifications do) so the client will recognize…
-
Create Report that Queries Every Schedule
Is it possible to create a report that queries every schedule, even the schedules that I do not have sharing privileges? I thought I could possibly do this through the SysAdmin account, or use the SysAdmin account to add myself to view all schedules. I am trying to create a report that lists all schedule entries labeled…
-
Row ID
Hi, I would like to be able to return the Row ID of a given column - to use in the following formula: =ROWID(ANCESTORS([Task Name]1)) Which should return the row ID of the first ancestor (Parent) or the current row. If there is no ancestor, I assume it would then return null or 0 Does a function such as 'ROWID' or similar…
-
Templates for Legal Project Management?
Does smartsheet have any plans to add templates for Legal Project Management (LPM)? LPM is becoming a neccesity in the Legal environment and is different from Technical Project Management. Curious if you are looking to add any templates for LPM? Thank you
-
Add a column showing the ParentID (or SiblingID)
Hi all, Is there a way to add a column which displays the ParentID to a Smartsheet? If I had this, I could produce the report I am trying to build I expect. Hep appreciated! Thanks, James
-
Formatting Parent Rows
Is it possible to format a parent row based on the number of children rows under it? If so, could you take it one step further saying like, highlight the parent row green if there are no children rows, yellow if 1 and red if 2. etc Thanks
-
How to compute Average Ratings on a Subset of Rows
Trying to put a formula that will compute the average rating based on organizational grouping. I have a smartsheet that has a drop down field which includes organization functions like: engineering, IT, Sales, Marketing, ... I have another field that is a numeric rating for these organizational functions. 1 thru 5. I need…
-
Templatizing
I have an extensive project plan with 250 sub-tasks, which is maintained separately for every client. As 95% of the task list for every client rollout, and the time allocated to every task remains the same; is it possible to automate this process i.e. I simply enter a start date for the project, and each and every task in…
