-
Enhancement Request: Calendar View things
1. In the Gantt view, user can select starting day of the week. The ISO standard is Monday, so it would be nice if I could show that in the Calendar View too. 2. I would like to set up a Report that shows the Calendar Two Week view and then publish it. However, it defaults to month view and can be changed by the end user.…
-
Setting Up Rules
Hi I would like to know how to set up a rule where if a certain selection is made from a drop down in a cell that it automatically prompts you to complete a related cell. For example: If a member of my team update the Recruitment Status for a vacant role to show 'Offer Made' I would like a prompt set up to automatically…
-
Streamlining sheets
We have a sales staff that is utilizing multiple sheets, for potentially the same client. I want to rundown the "standard" process to see if anyone can help streamline this. Sales speaks to customer, and enters into SmartSheet, almost as if utilizing like a CRM. This sheet will store details like Name, date contacted,…
-
Approval Alerts & Actions -Column Data visibility
Would anyone know how the approver could view certain column fields? I tried the Advanced Option and checked things off but it still does not show the data in the columns I checked off.
-
Claims Denial Management
Hello. I will be working on building out a claims denial management work plan but was wondering if one already existed within the abundance of templates?
-
count itmes in a column that is populated with multiple data
Hi guys, I have a new challenge for you :) . I have a list of projects. Each project contains different products. I have one probabilty column that contains all the probabilities to sell the different products contained in each individual project. An exaple: I have a project (1 row) where I can sell machines types A, B and…
-
Reports Overwriting data in Sheet
I have a sheet that I use for collating data of time taken on a particular works order. To compete a works order, it requires 3 seperate workstations. However, I have set up 3 seperate reports, linked to the one sheet, for data input. The issue I have is that if two workstations both enter data at the same time, and one…
-
Linking date columns
Hi, I am linking date columns from a master sheet to another sheet. When linked it seems to change the format of the date. For example if the date in the original sheet is 12/08/19 (12th August 2019) in the linked sheet it is displaying as 08/12/19 (8th December 2019). The original cell doesn't have any dependancies.
-
Tracking Time (Tasks)
Greetings, Looking into the prospect of getting my engineers to enter time spent against tasks in addition to 'guessing' and their percentage of completion. It seems the threads here are all a couple years' old or more - wondering if there's any advancements in this arena recently. Regards, jc
-
Using COUNTIF to find the number of Blank Spaces
I'm trying to count how many blank spaces there are in a given column. However, whenever I put in the below formula, it just gives me the total amount of rows in the column, but the entire column is not blank: =COUNTIFS({CDVL Project Tasklist Range 4}, "") I've also tried this formula, but to the same results:…
