-
Changing my appsheet data from google sheets to smartsheet. How to include multiple tabs in
Hello I'm new to smartsheet and still learning how everything works. I already have an appsheet app set up in google sheets but I want to change the data over to smartsheet, so everything is in one place. I notice smartsheet doesn't have the ability to have multiple tabs? How do you transfer the multiple tabs over to…
-
Workapp not loading Dashboard
Hi all Have created a workapp with a dashboard, a number of sheets and reports. Created roles and assigned pages to the roles with their permissions. All Smartsheet items that support the dashboard have been added to the workapp. When in design/draft mode I see the content including the Dashboard. When attempting to…
-
Pivot not using all of the data when column is contact type
I have done a number of Pivot sheets and have had much success. But I have run into a stumbling block where I am Pivoting on a sheet with contacts. It is only picking up some of the contacts, not all. Is there an issue with Pivot sheets when using "contact" columns?
-
Getting Text in Quotes ie. "Joe Jones" to get recognized as a Contact Name
I have an issue with this formula which work perfectly, the output of the Match is a Name, I want to enable that column as a Contact column, but i am having issues parsing out the "names" in quotes to be recognized by the contact API link (outlook). It will not convert Holly Jones or any of the others to an outlook…
-
Can Allocation column be tracked by hours?
Hello, Currently, I am tracking Allocation as a percentage within Smartsheet so that the data can feed over to our Resource Management account. I want to know if calculating allocation based upon hours is possible because the worklist within Resource Management is unclear with allocation as a percentage. Please let me know…
-
Calendar App / Contact Lists
Does anyone know if there is a way to NOT display a contact's full email address (but show their name, instead) when they are assigned as "Task Owner" in the Smartsheet Calendar App? We have a calendar that references an existing Smartsheet - Sheet. The sheet has a contact list column labeled "Assigned". When the this…
-
SQL to SMARTSHEET
Hello, Is there a way to populate SMARTSHEET from a SQL database without using Data Shuttle or Zapier? I need a temporary low-cost solution as we build SAP to fit our needs. If not, is there a way to have SMARTSHEET automatically refresh from an excel file? Thanks, Shahara
-
How can I tell if a report is a Dynamic Scope Report or just a Report?
Hello, I've tried searching for this question but was unable to find the answer. By looking at a report, is there a way to determine if it is a Dynamic Scope Report (i.e. pulls in new projects as they are provisioned) or a static report that someone made using various reports from different workspaces (not controlled by…
-
Is there any way to respond to an @mention directly from Microsoft Teams chat?
When receiving a tagged mention notification in Teams, it appears the only option to respond is to open the Smartsheet and reply there. Is it possible to reply back to the chat message and have it flow into the Smartsheet comments (i.e., like it does with the "reply to this email" option in Outlook)?
-
One DView that shows rows based on a team
I am looking for a way to reduce the number of views to build for a sheet that filters by team: Currently I have Team A, Team B, Team C etc. I build a view for each of the teams and set the "Restrict view by sheet filter" to the respective team filter We have a lot of teams and therefore a lot of DV's to build and…