-
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
-
Charting on non-primary fields
I have an Risks, Action Items, Issue, Decision and Questions.. (RAIDQ) sheet. The description is the primary column (field). I have created a few reports using the RAIDQ as the source sheet. I want to create a charts in a dashboards RAIDQ by Priority, RAIDQ by Status, RAIDQ by Category. I am unable to select any other…
-
Auto Email Notification
We are using the automated email notification to notify all shared users of changes to a sheet on a weekly basis. The email received by the person who made the majority of the updates does not show their updates, yet these are shown on the email received by all other shared users. I've not come across this issue previously…
-
How to configure a project assignment and the assignment date and show the rest of the fields diseab
I have a problem. When Smartsheet sends the form on request to an area. I need to know if after receiving a project from a form, to be able to assign a resource and the date of assignment I can only do it from an update? or there are other ways of being able to assign people and date of assignment, automatically without…
-
Collect Criteria not being filtered
My nested COLLECT function's Criteria does not appear to be working because the formula runs into errors when a duplicate date is found before the actual date that should be being pulled. =INDEX([Baseline Variance]5:[Baseline Variance]128, MATCH(MAX(COLLECT([Task Complete Actual]5:[Task Complete Actual]128, [Milestone Type…