-
View Ranges Used in a Sheet (or all sheets)
Hello, I would like to know where I can go to make edits to some of the ranges I created. Normally, I can see the ranges I have created by just clicking on the cell once (rather than double-clicking to edit), but my formula is too long and it pushes the range links off the page. Please see attached screenshots. Any help…
-
Avata CPD Enterprise connector with Smartsheet
Hi, Has anyone connected smartsheet to Avata ?
-
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!
-
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…
-
Gmail add on for Smartsheet
The Gmail add on worked twice, but now doesn't place the email into the spreadsheet. It still finds the spreadsheet and the rows, but when you either select an existing row or attempt to add a row the cursor circles for a few seconds then stops and nothing further happens. Not sure where to go next. Any help would be…
-
Hours of Work Within Task Duration
Hello, I am attempting to solve an issue we are experiencing with using Smartsheet for project management. Here is an example of the situation we find ourselves in... Let's say there is a task with a start date of 08/29/18 and an end date of 09/05/18. The task will be worked on within the allotted time but it only worked…
-
Non People resource assignment
Hi Hoe do I assign non people resources to a task. e.g. a piece special equipment to do a job so that I can see the utilisation of the equipment.
-
Countdown from today not working
I am having the hardest time using any kind of formula...whenever I type them in I get the unparsed error. I am trying to do a countdown from today to an end date but no dice. I find the explanations on here for how functions work aren't really helpful for me. I have turned on and off the duration function, it gave me a…
-
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!
-
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?…