-
Multi-tracking users in a locked column based on a cell change unlocked column for all records
I think this requires some function list designing, for the automation feature does not allow this based how our complex sheets are setup. In our tracking Smartsheet, we're trying to systematize the multi tracking of our users (Techs) into a locked column. User 1 (Tech 1) is assigned a record (ticket #) in "Assigned To"β¦
-
How to convert value from different cell into date format
Hi All, Thank you in advance for your advice. I like to convert values from the different cells into date format to capture the follow-up date in a report. How do I input the new formula in "Date tp follow up" Thank you Patrick Tan
-
How to Summarize the Assign to: Contacts in a Report
Hi There I see there is plenty questions relating to this topic, but what ever I try doesn't work. Here is what I'm trying to do: I want to create a Report on Multiply sheets. Each sheet has different Contacts assigned. Now I'm stuck on the Sheet Summarized Option. Here is my Screen Shot 1st Question - Under Summary Sheet,β¦
-
Row Count by Department
On my sheet, I have a Department column that is filled in on every row. There are about 1200 rows total. Some example departments are: Accounting, AP, AR, Benefits, etc. In addition, every row has a Status, Start Date, and End Date column filled out too. I have a dashboard for this sheet. I would like to add a bar chartβ¦
-
IF Formula for "ball color"
I am creating a sheet where you have to with a dropdown menu for each calender week (CW) in which you can choose between "fulfilled", "partly fulfilled" and "not fulfilled". I want to connect these field with another column where I use the ball symbols (fulfilled = green, partly fulfilled = yellow, not fulfilled = red) Iβ¦
-
Help with populating one column based on value of range of columns
I have a number of columns with either "High", "Medium" or "Low" as the value and am wanting to return either "Yes", "No" or "Maybe" in another column based a result in any of those columns. So if any of columns A - E contains "High" then column F should show "Yes" Thanks in advance for any help!
-
Equipment and tool Sign out and return
Hi all, I am looking for a solution for our engineers to sign out/in, tools and equipment. This way we can keep track of the company tools and see who has the tools/equipment in their van. This will prevent loss of equipment in the company. we have a list of what tools are in the store so they could select what tools theyβ¦
-
Countif with Dates
Hi all, I've read notes on other posts with similar dates but haven't been able to figure it out so asking here. Sorry for the repetition. I'm trying to count the number of cells in a column of dates that have a date prior to a date I have stored in another cell. I'm actually doing it with countifs but I can get the otherβ¦
-
Contacts on multiple lines in a formula
I have a sheet that is organized by company and then a contact person per line. So it looks like ABC Company John Smith Johnsmith@abc.com ABC Company Tina Jones tinajones@abc.com I want to write a formula in a different sheet that where I have ABC company, I can pull in both John and Tina's email addresses into one cell.β¦
-
Due Date Automation for Tasks
Hello: I have 2 quick questions regarding how to best automate/populate dates for project management timelines. Is there a feature (or formula) within Smartsheets that allows you to specify if a task is a reoccurring item? For example, if on the last Friday of every month, we are to pull a client report, how do I set thatβ¦