-
Auto Status Change/Update
Hi, I am trying to create a tracked schedule and was wondering if smartsheet had an option or setting that auto updated status based on the date entered and real time date. For example if a phase is due at 08/24/2018 and it is 08/25/2018 and the status box of completion is not checked yet, is there a way to create…
-
Add additional filter or how to do this
Hello, I need help to do something if possible. From my table, i want to make a filter which will show just the rows which has the specific terms. Ok, this is easy and I know how to do this. My issue comes when I have one more column where the fields containing numbers from 1-5. So, I want to somehow make additional filter…
-
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?…