-
Troubles with inputting a value for notification
I am creating a sheet to keep track of a budget process. I am curious why a notification does not get sent out when I input a value by typing it in when using the "is one of" condition? The notification only works when I already have 100% typed in the column somewhere, then I have to select it from the drop down box. Why…
-
Automated Email updates-- SUGGESTING MORE EFFICIENT FORMAT FOR COMMENTS
Hi All-- I LOVE SmartSheet but I really wish the AUTOMATED emails that are sent that include the COMMENTS section could be setup like the emails that can be sent from manually selecting the "send" function on a row; which places the message ON TOP of the row information. Said in a simpler fashion--PLEASE PUT THE COMMENTS…
-
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",…
