-
Blocking Actions on a Spreadsheet
We use Smartsheet for our work holiday/vacation planner. We don't want holiday overlaps so I would like to make it impossible for 2 employees to select the same dates. Is there a way to block actions? Is this something that can be done? Thanks in advance!
-
Simple Calendar View for Mailing Schedule
Hey there, I created a grid to show a mailing schedule for affiliate promoting a product launch. I made the primary column for the names of all the affiliates, and then I made date columns to the right for all dates between Sept 5 and Sept 21. Then in the rows for each affiliate name I went across the grid and entered the…
-
Automatic 'Text Wrap' Feature in Grid View
Hello and thank you in advance for your time! One of the sheets that I use prequently has text wrapped automatically in the grid view. This has only started the last couple of days so I imagine someone in the building has changed this by mistake. I have been tasked to change it back. However, I do not know what I'm doing…
-
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?…
