-
sending tasks from one smarsheet to another
Hi all, I use a smartheet to receive inputs, considered as a task, with a form. when the team fill the form, it became a line in my worksheet. I have to check this tasks and if I consider I have all inforation is goodand the task shoudl be exectued, I woul like to click in a cell and this line sould be updated, or mirrored…
-
Booking Calendar
Has anyone used Smartsheet to setup and use a "booking calendar"? Specifically, if I have 4 companies that are able to use 3 different conference rooms and I was wondering if I could set up a view of the schedule of those rooms and allowing the booking of those rooms via Smartsheet instead of an outside app. Many of those…
-
Automating Responses Between Two Smartsheets
Hello, I have two sheets that I am trying to connect in a specific way. The one sheet, Config Mgmt, has a Labeling Progress column with two dropdown options and six additional columns where users can input text. The other sheet, Labeling Sched, has a Document # column where users can input text and a Status column, which…
-
Pivots and Scatter
Hi all, I"m hoping to get more ideas on how to best display my data. I track headcount and hiring for my team, I have created a column that will provide me with the age of the role (how long the role has been "open" for, in days). Because I run multiple portfolios, I set up a pivot that breaks down each Portfolio and the…
-
Font color changing when I insert a row
I've started a project plan and every time I add a row, it turns the font color from black to light grey which I can't read. I have to highlight the whole row to change the row. I have highlighted the entire sheet many times and changed to color to black, but it doesn't stay in black font when I add rows. As I have just…
-
Share multiple workspaces at one time
I have a new colleague that I want to have access to all of my workspaces. Is there a way to share all of my workspaces at one time without having to individually share each workspace? I have over 200 workspaces.
-
Repeated Custom Message on Alert/Notification
Hi Team, Can you please confirm on the process to limit the Custom Message to just once. It is bizarre that the customer message is being repeated a number of times that equals to the no of Open tasks being reported. I deleted the custom message for my other notifications but wanted to check for a work around this time.…
-
Setting up date Regional format for enterprise account
Hello, I'm managing an enterprise account with people in different part of the world. I also have Control Center to collate and generate project information. I've set-up my sheets template in CC to manage date in the European format DD/MM/YY or DD-MMM-YYYY. I'm using the VALUE formula to generate a date (DD-MMM-YYYY)…
-
Match Problem
compared the column from one sheet to another sheet Sheet1: ID Sheet2 : EmpID i can able to Match all the data which is under ID column to EmpID but if the ID Starts with 0 its not comparing. EX(0123) I used this formula =IF(COUNTIF({check1 Range 1}, EmpID@row) > 0, 1, 0)
-
RE: Barchart and percentage
Good day, I am wondering if someone would be able to help me to create a barchart on a dashboard so that the scale remains 100%. When I try to do this its displaying 100%. Any help will be grateful. Thanks in advance.
