-
Contact list in forms
My sheet has an "assigned to" column, but I am wanting to reference my contact list for the available options. I know when I am directly editing the sheet, I can begin typing the contact name/email address and will see a list of available options - but the same feature is not available on through a form. Is there a…
-
Formula to Flag a Task if it's Predecessor is Delayed
Hi all, I am trying to develop a formula that flags/checks a box for tasks whose predecessors are delayed. Please see below for additional requirements and my work/understanding so far: Sheet Details: I have Predecessor and Successor columns with those names. My task column is named Milestone / Task My finish date column…
-
MS Teams asks me to log in on a daily basis
Each time we are accessing Smartsheet via MS Team we have to log in again. It will than remember the credentials, but the next day it starts all over again. It's giving the following message: Please log in to your smartsheet account to access this published item. Is this a known issue and is there a solution for it? It's…
-
Data Collection
Hello I am trying to create a sheet to manage my labels inventory and I want to find the best way to enter existing inventory into my new created sheet. I have created a form with the two required fields, i will be using one handheld scanner to read the data from bar code labels, I would like to know if there is a way that…
-
Removing a field from the Summary & project sheets
I have a field coming from one of my project sheets feeding to my Summary sheet that's been replaced / is no longer needed. I'd like to remove it but wanted to know if there was anything I should keep in mind. If I just delete the field from the summary sections of all my projects & delete the column in the Summary sheet,…
-
formula for past date
Is it possible to use the same formula but different length of time in the past? IF(AND([Quote]@row <> "Completed", [Date Sent]@row <= TODAY(5)), "Green", IF(AND([Quote]@row <> "Completed", [Date Sent]@row <= TODAY(10)), "Yellow", "Red")))) If today is 04.15.2024 and I need the symbol to change color as days past...…
-
Any ideas with an issue displaying web content on dashboards?
I've been experiencing an issue since yesterday with displaying a web content widget that pulls content from Excel. I get a Microsoft login page in place of the widget and when I click Sign In, it says I am already logged in. I can access the file outside of the dashboard fine in Sharepoint. Any ideas would be greatly…
-
Help With Communication Plan template - Can't change columns in report
I am working with the Communication Plan template and in the "reports" I cannot change the columns to match the plan I built. It is grayed out and says I have to be an admin. I upgraded my plan and got a license but it still won't let me change it. Since I cannot match my summary reports to the categories and delivery…
-
MAX(COLLECT({Range 1}, {Employee Range}, @cell = Employee@row))
This discussion was created from comments split from: INDEX MATCH with MAX.
-
Data Shuttle Error
Hello, I'm just uploaded a new excel doc and am trying to run Data Shuttle so the information on my sheet will update but it doesn't appear to be working. After it finished running, I checked and it said no rows were updated so I was checking the workflow and keep receiving this error: I've checked my rows and everything…