-
Data Mesh
I set up a Data Mesh to sync contacts between 2 sheets. The goal is to sync the drop down contact list. Both columns are set to Contacts. However, when I get to the set up screen Confirm and Create, the Lookup Values field in the Source sheet is black and I can't manually add it. IT was set up correctly in the Map Sheet…
-
Start and End Date in RM in Projects
Im not able to figure out how to sync the start date and end to actual project plan. Currently the dates showing in RM are from Intake Sheet which is the Target Start and Target End Date which are estimated dates. This is entered initially when filling out the NPD form to start the request of a project. Once the project is…
-
Control Center Profile Data - Appearing in the wrong column
Hi, I think I have a strange behaivour in one of the Profile Data parameters set in Control Center. Even that I do designate a Target Column as "Date" for the Profile Data in SCC, this data keeps appearing always in the default column in the template: text/number column to the right of the Primary Column in the template…
-
How do I show both birthdays and anniversaries on the same calendar?
I want to add a calendar to my team's dashboard that shows both Anniversaries and Birthdays every year. I have the following columns: Team member Date (date of anniversary and birthday) Anniversary column to show this year's date (formula) Birthday column to show this year's date (formula) When I go into calendar mode, I…
-
USED TO BE ABLE TO COPY AND PASTE WITH BLANK CELLS IN EXCEL, NOW IT SKIPS IF BLANK
I've seen this question in previous discussions but it's been several years. Every single day I copy and paste from excel into smartsheet and every single day there are blank cells in excel that populate blank in smartsheet - UNTIL TODAY. In the previous discussions it seemed to just be a thing that it would skip over…
-
Duration, start date/end date
This discussion was created from comments split from: Calculate start date based off of end date.
-
Actualizacion Aplicación
Hace poco actualicé la aplicación en mi movil Android y lamentablemente me dice que la aplicacion ya no es compatible con el dispositivo. Sumado a eso la version de aplicacion movil de Smartsheet me está pidiendo actualizacion y tampoco me permite dejarla usar. Alguno sabe que puedo hacer en ese caso?
-
Data Shuttle Errors (Column mapping, other?)
Hi All - We are using Data Shuttle to offload content to sharepoint for the first time, and I've made sure my headers match, etc. I've tried both CSV and EXCEL. I'm at a loss at this point, and have seen others suggest similar issues without much detail on 'resolution' - any insight is greatly appreciated. Same error, same…
-
I cant open any of my sheets
-
If Formula to return highest priority
My spreadsheet has 4 columns are updated each Month with Stable, Improving, Developing, and Negative. Negative is the highest priortiy, then Developing, then Improving. Please assist with a IF statement, that would look at all 4 columns an update the cell with the highest priority word.example 3 stables and a developing…