-
Sheet summary values not updating on dashboard
I'm having issues with fairly basic date based formulas not updating in a dashboard. A sheet I have that has 7 Columns 23 Rows 0 Calculations on the sheet itself and 3 basic formulas in sheet summary columns =IF(COUNTIFS(Date:Date, TODAY(), Shift:Shift, "1st") > 0, "Green", "Red") =IF(COUNTIFS(Date:Date, TODAY(),…
-
ALL conditional logic not working on Form
None of the conditional logic is working on the form - though when I make a copy of the smartsheet, the copy's form is working as expected? Could there be some sort of default that is assigned when a copy is created? I am suspecting the issues lies in the smartsheet itself - not the form. As the form logic has not been…
-
Gantt Chart - linking start / end dates
Im a beginner so bare with me. Im creating a GC where the beginning and end part of the process are irrelevant for the C suite - only interested in hard deadlines and the overall duration of the project minus the grey areas. However, these task rows and durations need to still be included to help manage the work flow for…
-
Is it possible to see how many people have opened a form link?
We have sent out a survey and are trying to see if people are opening the link to the form and are working on getting the information together (it is a lengthy form) or if they are not even looking at it. We don't necessarily need the who has viewed it but just the number of times the link was opened. Is this possible?
-
VLOOKUP and links in the linked cell
Hey community, if I use VLOOKUP , and the linked cell (Cross reference to another sheet) itself contains a link, the result in the cell, where the Vlookup formula is inside, returns aonly the text from the link but not the link itself. Any idea? Thanks Kay
-
When running VLOOKUP how to bring over the URL value into (this is to bring over a picture on a cell
I am running VLOOKUP to bring a picture located in a specific row cell over a new sheet cell. The issue is that picture comes as a text (picture name). My ultimate goal is to pull that picture into a dashboard, when trying that, just the text comes If I bring picture directly from the smart sheet where picture is located…
-
Does anyone have a template for a document repository sheet?
I want to create a new sheet that can be used to list all of the latest versions of the project documents and other useful information that all my project stakeholders can easily view and access. I can then add the document as an attachment to the relevant row in the. So the column headers could be 1) Document Type 2)…
-
Assign one of multiple contacts as a task owner
I have a project plan that currently uses 2 columns for task management: Assigned To: resource that is the owner of the task Additional Resources: resource(s) that will also be working on the task Rather than having two columns, is it possible to have all 3 resources in 1 column and identify Resource1 as the owner? Thank…
-
Formula Help
I have two sheets one the information is going to be fed into from a form lets call this "Training Completed" so when the info is in this is what it would look like Then I want it to populate the next sheet with a 1 if they have completed the training So in this example it should look like the below if the formula is…
-
Is there a way to see who an automated notification was sent to?
I have a workflow set up that is based on using the symbols column. We have a ton of potential volunteers that have filled out a volunteer form and those that are marked as a 4 star or 5 star are then sent an automated email based on the email they entered in a contact column. The automated email instructs them on next…