-
Auto populate from one sheet into blank rows on another
Hi All! I searched for this, but couldn't find an answer. Maybe it doesn't exist! I'm trying to set up a new dashboard for sales reps. In one sheet I will have them fill out all of their activities. I was TRYING to get them to fill out all information on one sheet to keep things simple for them. Is there a way for me to…
-
Sharing Many Workspaces with Two People
Hi, Attached is a screen shot of my workspaces. Those workspaces that are highlighted I want to share with two people. Is there a way I can send those two people one “sharing email” that will give them access to all these workspaces? Or do I have to send them a separate “sharing email” for each workspace? Please advise.…
-
It does not record what I keep
I am very worried because every time we register something we can not see the changes that we have made in a sheet, if another user enters he does not see what I already record or save. We have a week with this problem and I am also very upset because the smartsheet reliability is lost, Fernando Alonso
-
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'…
-
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!
-
Excel Formula Error
Hi All, I've referenced the forums for help and thought someone might help me with the "unparseable" error I am getting. We are trying to do complex formulas: =COUNT(IF(FREQUENCY([Listing Key]2:[Listing Key]20)>0,1)))) The "[Listing Key]2:[Listing Key]20" reflect the chosen cells to crunch the formula. Attached is a…
-
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?…
-
Looking for some guidance: need recommendation on the best template to use with client to track feed
Hi to all and thanks for considering my request. We're somewhat new to SS, have looked at all templates without finding a product evaluation feedback form that would allow users to share issues, insight, feature requests and help requests for a 30 day product evaluation period. I'm not expecting to find the EXACT template,…
-
Update Request Rules vs. Manual Update Requests
When I send out a manual update request it says my username via Smartsheets, and if someone hits reply, it goes to my email. If I set up an alert and action, it comes from Smartsheet Alerts & Actions, and if someone hits reply it goes to automation@smartsheet.com, and I never see this email. Is there a way to have the…
-
Bar Code Scanning for event registration
I am an event coordinator, and use Smartsheet mainly for managing my events. It is a great tool for keeping track of to do lists, timelines and event details. I even use it to collect RSVPs. What I'm wondering is if anyone here uses Smartshee's bar code scanner for event check-ins, or if anyone uses a third party…