-
Form link
Hi - I have a form created, and want to embed the link on our corporate website. I would like to know what will cause the link address to change, ie. does changing/editing the form cause the link to change? (and then I would need to get the webmaster to update the link). Thanks, Olli M.
-
Tracking purchases
Trying to assist my purchasing department... I've set up a sheet for a department to enter their purchases, but my issue is that our purchasing dept wants to have it itemized. For example, I might have an Amazon order for $1000.00, but that $1000 is comprised of 1 printer that's $500 and a computer that's $500. I'd like to…
-
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