-
Smartsheet Merge & Google Sheets
Does Smartsheet Merge App work with Google Sheets? I have been using the Smartsheet Merge App with the Google Docs, however, when trying to use it with a Google Sheet, it doesn't appear on the list. It seems a shame not to be able to when Google Docs does..
-
Smartsheets for medical practices
Does anyone know if smartsheets solutions can be used to manage medical projects? This would include documenting information that would flow via api into an existing enterprise system.
-
Task Name data not available from SSIS odbc connection
I have developed an SSIS package to read Smartsheet data, and then export the data into SQL database. I managed to export the data but noticed the Task Name, % Complete, Status fields are returning NULL values. This doesn't make sense because these fields are populated with data on Smartsheet. Please assist.
-
Testing of Portfolio Management Features
Dear , As I am currently testing the portfolio management features of Smartsheet , would you please provide me with the following pre-formatted templates mentioned in your pdf : Project Portfolio Roll-up ( i did not find them via a Google search) : 1) Portfolio Master Calendar 2) Portfolio Risk Tracker 3) Portfolio Score…
-
Search using wildcard* not locating content in a sheet
Hello, Today a user asked how to make the searches in a sheet less restrictive. I offered the wildcard as a solution and as we were walking through the search it found 0 results. Within the sheet I have a column with a customer part numbers including revision example: 111-111111_RevA. I perform a search for the part number…
-
RACI Template
Hoping someone can help steer my in the right direction! IN the project managemet tools there is mention of an RACI template however when I log in it does not seem to be there? Am I looking in the wrong area or is this some secret enterrise level only template... Thanks Nik
-
sumif date is today to end of month
Trying to write a formula that doesn't need manual updating that basically sums a total amount for file that have a closing date from today to the end of the month. Seems like it should be fairly straight forward but I cant get it to work. The sheet has parent rows but i want to include all rows in all parent rows in the…
-
Nested IF AND & OR
Hello, I'm looking for a good formula to collect the number of remaining days to work. This works fine: =IF(OR([Assigned to]110 = "User1", [Assigned to]110 = "User2"), [Closing date]110 - TODAY(), "0") but If I want to add one more condition like at row status it doesn't works: =IF(AND((OR([Assigned to]110 = "User1",…
-
Slow Response Time
Hi all, Is anyone else struggling with slow response times from Smartsheet. I have around 40 sheets that i work on, and 1 tab open. Even simple tasks like moving the mouse and clicking on a cell or an option is taking around 30 seconds to complete the action. I have tried this in empty sheets and still finding the issue so…
-
Programme RAG
Hi All, I have a roll up sheet for the programme of work, each line is a project that is being worked on or queued for work. Each line has an Overall RAG called ''Overall Status''' for the overall project and I have a metrics table which states the Programme RAG, currently this RAG for the Programme would be manual, i…
