-
Calendar Tasks to outlook for assigned tasks only
I published the iCal link to my outlook calendar, the problem is that every task on the Smartsheet shows on my calendar. We have around 15 people to whom tasks have been assigned. It would be great if we could link just their tasks to their calendar. Having all the tasks clogs up the calendar and is pretty much useless. I…
-
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!