-
Cannot sort Card view by Assigned to column
Hello I am using Smartsheet to allocate tasks for projects which i use gantt and grid view for. My team need to look at their tasks allocated to them in card view, but i am not able to sort the card view by the assigned to column I do have multiple contacts enabled in the assigned to column, would this cause the problem?…
-
% Complete is Not Working
Hello, I have a spreadsheet with about 85 tasks and subtasks, the % Complete isn't working. It's show the percent completed as 99%, when only about 10 tasks have been completed for this project. I tried to disable the Dependency Settings and use the =AVG(CHILDREN()) formula but then I got the divide by 0 error. So then I…
-
Reports not listing entries when it should
Hi there, We manage store fitouts. With every project, the sheets are identical. I have created 16 sheets to manage 16 projects. I have just recently added few rows, all identical, on all 16 sheets. When I run reports, it does list certain rows (newly created). Puzzled, I simplified the report to the bare minimum: I now…
-
vlookup w/ resources and dates
We are working on a manpower tracking sheet and trying to create a link from one spreadsheet to another, which will lookup a resource and then find the latest date that resource has tied to it. This will allow us to see when we have someone coming off a project and has not been assigned to another project (on the bench).…
-
Loss of Function - Select/open multiple
We were able to browse any workspace or folder of favorites and select multiple sheets from them. then open them all at once - but this feature is now gone. Checked the text of the announcement. It says that in order to do the thing that was already working in Smartsheet, you have to use some other system built into the…
-
Importing Task Hierarchy from CSV file
We are looking to establish a daily import of our project portfolio into SS via a CSV file. When I look at the task import schema, I cannot see a way for SS to identify the parent and child relationships between the tasks. This means we cannot import nested tasks and the task hierarchy. Do you know if there is a field and…
-
Countifs with with percentages
What am I doing wrong? The formula was fine when I did the tower in air dates from today - 12.31.19, but as soon as I tried to add the condition of lease probability being above 49% it doesn't work. Any thoughts are greatly appreciated! =COUNTIFS({C. *Ground Lease Tower In Air Date}, >=TODAY(), {C. *Ground Lease Tower In…
-
Smartsheet Dashboards vs Live Data Connector Integrations
Hi everyone, Has anyone used the live data connector to integrate with another platform such as Qlik or any other? I know that SM now has the dashboard view, but I do not think it is as powerful as other BI platforms. From what I see, the SM dashboard is a very high level overview and does not give the level of detail that…
-
Extracting all instances of a word from a text string and creating a list in a separate cell
Hello all, I have been pouring through excel and smartsheet help forums for a couple of days now, and I haven't seen my issue asked or addressed so thought I'd ask here. I have, in one column called Terms, cells that contains lists of terms and phrases. For example, one cell contains the following text string:…
-
Inter Project dependencies
Hi, I have multiple projects to be managed under a program. I have a task1 under Project A which has dependency on task2 of Project B. How can I mark dependencies between two project tasks? thanks, Pragati
