-
Trigger an approval workflow by changing a existing cell value
Hi, I have a multi level workflow approval setup which cascades project approval requests through a series of managers. The project list consists of a sheet of agreed projects so the only way I have been able to trigger the work flow is to have a specific cell for each row which I change in smartsheet to submitt. this then…
-
Using SUMIF to provide value of orders from this week only
Hi, I am trying to get a formula to sum the total value of orders invoiced this week. The formula i have tried is below, but returns '0' as the value. =SUMIF({Completion Date}, {Completion Date} = WEEKNUMBER(TODAY()), {Order Value}) The sheet references are to single columns titled 'Completion Date' and 'Order Value'…
-
Can you have a character limit in a Web Form text box?
Is it possible to have a character limit in a text box within a Web Form? We've limited the number of lines to three, but would rather limit to a specific character count. Appreciate any insight!
-
Automating the Date on Forms
I have set up a new form for customer orders with a 'Date in' option however, I would like it to be set to todays date automatically. Is this possible or will we need to fill todays date in each time an entry is submitted? Thank you in advance!
-
Google Form Sync with Smartsheet
Hello, I had a few questions regarding syncing Google Form responses to a Smartsheet. I've followed the instructions and have connected the two but the responses aren't being recorded in the new sheets. Is there usually a delay or is something not working properly? Also, I have some "untitled' questions which is used to…
-
Default date to today with webforms
Hi Anyone know if you can default a date field to today's date to avoid having to fill it in everytime? Regards Andy
-
Web form populates parent/child relationship through category
Hello, was hoping to get some help on an issue i am having .. we have an inventory control sheet .. we would like to use a web form(s) to not only take out something of the inventory but to also add something to the inventory. I added a Category column and that is reflected in a dropdown list that matches all of the…
-
Changing the Color of the Submit Button
I am looking for some help as I'm new to smartsheet and still learning the ropes. I have embeded a form into a Wix website for a client however I would like to change the colour of the 'Submit' button to fit in with the website aesthetic. Can anyone let me know if this is possible and if so, let me know how to edit this?…
-
Match Two Entries from Two Separate Form Sheets, Assign Status
I have an "Assignment" form that creates a system generated number. The crew foreman will use this form for their assignment, then they will populate a "Production" form using the system generated number from the "Assignment" form to reflect the production done for that assignment. I'd like have a RYG ball on the…
-
How to easily capture Actual Time spent on a Task in SmartSheet?
Fellow SmartSheet Community Members, We have recently started using SmartSheet for planning out a roadmap for initiatives, along with types of roles allocated to the initiative (resources) as well as allocation. We are now looking for creative ways to capture "Actual" time spent on a particular initiative. Here are our…