-
Index/Lookup formulae
Hi Team, Can you please share what sort of Index and match formuale would we write to bring in the Project ID on the New sheet The project name on the auto updated is a combination and can be searched and then corresponding project id needs to be populated
-
How to combine multiple project plans into one, but keep separate editing access?
I am running a program that contains 17 different workstreams, and each workstream has a separate PM that is running their own individual plan. We want a view where you can see all of the workstreams together in a 'program' plan. We consolidated all plans into one but this has created a large number of issues as we have 20…
-
How do I link data back to Intake Sheet from Metadata?
I have an Intake Sheet (New) Project Request Sheet to provision a project with a set of templates. Within the set of templates I have a Team Roster, which is used to request resources such as a Project Manager, R&D, Engineer, etc by a check-box. This check-box data is written to the Metadata, and then also written back to…
-
Copying data from Summary Sheet to another sheet
Hi, We use the summary sheet of project plans for PMs to update the overall RAG and add any specific comments about the project and it gets pulled to Dashboard for reporting. However, I am also trying to create a repository of "overall status RAG" to observe if there is a trend over the life of the project. To do this, I…
-
Chart Widget on dashboard
Hello, I have created a report in order to create a chart widget in a dashboard, which I did, but because the variables are 2 large categories, this looks very big and it doesn't look good on the dashboard. What I would like to display on the chart widget is how many types of transactions are by location since the…
-
Master Sheet Connected to Department Sheets - Best Way to Control
Hi All, Looking for some advice on the best way to proceed. I have a Master Sheet that a coworker and me maintain. We would like to break out this sheet into different departments and have their administrative assistants maintain, update and add attachments to their sheets, thus updating the master sheet. Is this best…
-
Custom Form URL
Hi Community. I am trying to use custom details at the end of my Form link, but not seeing it populated in my Form. Simply, after my Form URL, I am adding: ?Name=Bruce When the Form is displayed, the Name field is still blank. What am I missing?
-
marketo.smartsheet.com is in the spam RBL list
Received this alert from our spam filter: Rejection Description: IP Found in RBL Event Time: 2022/05/12 at 13:19:23 Rejection Information: spamcop.mimecast.org Blocked - see https://www.spamcop.net/bl.shtml?199.15.212.139 From: 464-onm-149.0.964529.0.0.61078.9.256108440@marketo.smartsheet.com To Address (Pre Checks): - To…
-
Examine range, find specific value in a row, then return the value two columns over?
I’m trying to do something with Smartsheet, and getting a little lost in the complexity. What I want to do is examine a range of cells, look in a row, find specific text (entered from a 38 item pick list), then return the value that is 2 columns/cells over from the found text, then SUM all such values found. I think an…
-
Recurring form submission error
We continue to see this error on forms connected to a specific sheet, even with all inputs given, required or not: The information you entered is incomplete or invalid. Once the error has occurred on a form, it persists until "fixed". No one can submit new entries with that form, neither external users nor users in our…
