-
Developing page links via API 2.0
I'm in the process of creating a Master Task List that will incorporate tasks from across multiple sheets so that we may create dependencies across departments. My problem is that I need the Master List to update automatically as the sheets informing it do, but cell linking will not account for new rows added or deleted to…
-
Smartsheet Navigation
I have always found navigating between sheets a bit cumbersome. I have several workspaces and lots of sheets. Currently the fastest way to find a sheet is to do a search. The favourites is a neat idea but I usually gave to navigate out of my current sheet to the home tab and then again to the favourites tab. What would be…
-
Issue: Being prompted to save changes when I've only viewed a sheet
Good morning, I don't know if this is a known issue or not. In Google Chrome I've had this happen several times. I've viewed a sheet to just look at the latest info and when I go click out of the sheet I am prompted to save my changes - but no changes have been made. I don't use other browsers, and it seems to be…
-
Hiding Completed Projects in Task Report
Good morning, I'm creating seperate reports for each of my users which pulls in all of their tasks. I'd like to remove or hide the tasks that have a '100%' listed in the '% Completed' column. I've added the '% Completed' column to my report and set up the 'What?' to exclude anything in which the '% Completed' cells contain…
-
Formula Help Error Message NETWORKDAYS
New user of SmartSheet and not too adept at Excel. I am trying to make a formula IF/AND so that there is no error message in a cell that uses the NETWORKDAYS functions if there are not dates in the two source columns. E.g., Job Complete-Est and Job Complete-Actual only have a date in neither or one So, if there is not a…
-
I would like to send my sheet to users for viewing purposes and only want them to have the ability t
I'm sharing my sheets w/ external vendors and want them to view all the data but only update their comments (1 specific column). 1) The update request does not allow the abiity to change some fields from edit to view only. 2) The update report is ok but does it send a request to the spreadsheet owner? So far i'm not…
-
Trying to create a fancy email with status reports from multiple teams
I'm trying to go a bit above and beyond, using SmartSheets to track the status of multiple projects across multiple teams. Currently, we have links to multiple sheets (one for each team) and they manually go in, add a new column per week, and fill it in with a bunch of text explaining the status of that project this week.…
-
Need the ability to filter reports based on project status
Here is what I need. I have about 50 projects within a workgroup that I am trying to manage. I have a report of tasks that are due within the next 5 days. Took some cluncky work to differentiate tasks vs summary tasks, but it was easy enough to do. Next issue / challenge. When a project stalls for some reason or another, I…
-
Dependency between multiple RYGG cells
Hi, Is it possible to create a complex dependency such that a task's status is derived from it's sub-tasks' status. i.e: Status Task AVG(ST1-4) ST1 R ST2 G ST3 G ST4 Y That way we could avoid manually updating task's status manually and also connect it between sheets. Thanks
-
Changing to Office 365 login
Good morning, We now have Office 365 for some of our licensees/users. How can I integrate my current Smartsheet account under my old email address with our new O365 email? FYI that I do have the Smartsheet app for O365 Outlook installed and am already using it. Blessings, Loann
