-
At Risk Flag Formula issues/questions
I searched through the Community and found a couple of formulae that either directly addressed what I want to accomplish or I thought could be modifed to do what I want. I get the #UNPARSEABLE error for each of them. I'm sure I'm missing something basic (new user) since all of the responses to the solutions are positive. I…
-
Formula to check a box when date entered + 2 days
Does anyone know if it is possibly to set a box to check a certain amount of time after a date is imputed into a row. For instance, we need a lag time on a project complete date of 48 hours. This is for a manufacturer that needs 48 hours for stain, etc to cure before project is technically complete. This is the formula…
-
Legal projects/task management sheet
Hi, I’m part of an in-house legal department. The company has different departments and different types of contracts/advice they require us to produce. To track the work, I have created one sheet for the legal team to use, covering all main "legal work" categories and then broken down to sub categories, tasks and then sub…
-
Countifs project status is neither complete nor cancelled
I'm new to this, and I'm having issues with counting the number of projects where Project Type = X and Project Status does Not equal Complete or Cancelled. I'm fumbling my way through unsuccessfully. This will go on a dashboard where I have other working formulas, but this is out of my expertise. Here's what I have so far.…
-
Add RTF (rich text formatting) to Comments
When creating a project many times the comments are as much instructions, as comments. Just like this modal when creating community comments, add the ability to apply Rich Text Formatting; Bold,underline,bullets, and numbered lists. RTF functionality would be limited to manually entered items, not pasted items. The…
-
Trying to count multiple people in a cell
I have a column set as Contact List and the Allow Multiple Contacts per Cell field is checked. I am using COUNTIF statements to count how many people are assigned to the tasks for a dashboard. I am using the formula: =COUNTIF({Project List Range 3}, Assigned1) Where Project List Range 3 is the Column in my master sheet…
-
HELP
Excuse me, my english isn't very well. I need your help. When I want to put an URL in smartsheet I click in the box to join an URL and on my mouse but nothing are been proposed to me (cut, copy etc). My mouse works very well except for that
-
Using daily report template
We're new user trying to understand how we can use daily schedule template to repeat itself on-going basis. When I go to settings it is grayed out so there goes that option. Spreadsheets are not something I've used too much and support is slow getting back to me
-
Avoid access to smartsheet when request for update
First of all, english is not my native langage, please excuse my mistakes. Hello all, I have a smartsheet with several external counterparts (customers and providers). I manage the smartsheet which is not shared and nobody is able to reach / open it. I send requests for update with automatic processes. but when counterpart…
-
System Column - Last Modified
Hi everyone! Im having issues with a status column. My goal is to update the status if a job has hit 10 days or more and has not been approved yet. I was going to trigger it by using the (system column) "Last Modified" Here's the problem: If someone only "views" the sheet & doesn't make any updates, every single row in the…
