-
I cannot seem to cross reference a sheet to another sheet and im going insane
Hello I know this might be very simple but I have tried everything to cross post a value from one sheet to another and I always get the wrong ref error or the unparseable one, this is the formula I'm trying to use, please help. =COUNTIFS({RE Projects Range1}, "Counter", {RE Projects Range2}, "Complete")
-
Raffle Type System in a Smartsheet Form
I am looking at trying to build a multi-select option raffle form. Lets say a form user has 5 options or "tickets" they can put into a bucket of goods for a raffle. I would like for the user to put in any combination of entering tickets per good that they can with the five tickets they have. I will put in a picture of what…
-
Can "Viewers" download/export sheets?
In the new USM, are users who are designated as Viewers only able to download/export sheets they are given access to e.g. to Excel?
-
Gnatt Chart Publishable Link - Troubleshoot
We have a company dashboard and we link a publishable gnatt chart (editable by anyone) in an iframe for users to make changes. We all have licenses to Smartsheet but this helps them make changes to a company wide sheet without having to leave the company dashboard and go into Smartsheet. I am unable to get the gnatt chart…
-
What do you use for your Sheet Reference Name?
Do you use the standard {Sheet Name - Column Name} ? Or do use a simple name that can be easily identified? Or Do you use abbreviations? Im curious and would like to know your approach, Im hoping I could learn a lot from your experience.
-
Plan Asset Manager - will it capture orphaned assets already in the system?
Hi, I missed the memo on the addition of the Plan Asset Manager role, and just assigned our admin account this role today. I did some digging because we had a person leave recently who didn't transfer assets before she left, and now we cannot access these sheets/reports. When we deleted her profile, we thought we…
-
Help Needed
Hi All, I am trying to create a formula to work out the number of days ( Helper V1 ) between the VISIT 1 and VISIT 2 days column. Any thoughts would be greatly appreciated Thanks
-
INDEX - Collect question
Hi there, I have a project where in the project plan, based on the start date selected for a task, I'd like Smartsheet to reference another sheet (which is the table of Sprint, Start Date, Proposed Completion Date, Sprint Label) and populate the Sprint Column with the correct Sprint Label). So the formular should check…
-
Hyperlinks in Sheets/Reports Should Open in a Separate Tab/Window
Hyperlinks in Reports/Sheets should open in a separate tab rather than the current tab. My users would like hyperlinks in reports and on sheets to open in a separate tab or window. The way it is now makes it cumbersome to work off a report. There is not an option to right click and open in another window either.
-
Is anyone using a "ai service" for meeting notes and importing into smartsheet?
Hello - we track client meeting notes for our projects in a smartsheet. We use a parent-child relationship for the meeting titles, and the children are all of the topics. We track open and closed items with assigned to and dates. We might have 20 meetings for a client. It works pretty well. We are recording the meetings…