-
Current user in dashboards
Hi All, I've seen an old message on this topic, but I'm writing to see if there have been developments since (or any work-arounds) to getting "current user" to work in dashboards. I love the new charts, and formulas for presenting summary information. However, for our organisation the real game-changer will be when a…
-
Can I add/update rows across multiple sheets within a workspace?
I'm wondering if it is possible to add or update rows within multiple sheets in a workspace? To provide further context, we currently manage projects by using a large checklist within a sheet. Often we will have a company process change and the only way I know to update the process for each project is to open individual…
-
Cannot generate - Smartsheet is showing below error
I need some urgent help with an issue with Smartsheet. We are working to generate the onboarding decks for the approval meetings this week, but SS is giving us an error when we try to generate them. Please see the screenshot below of the error message. Please help it's urgent
-
IF formula for date and text in the same cell.
Hi, I currently have this formula for a cell: =IF(AND([Quote Validity]62 < TODAY(), ISDATE([Quote Validity]62)), "EXPIRED") However, if I need to put anything other than a date for Quote Validity cell. It returns an "#INVALID OPERATION" What needs to be added to that formula so when a text, besides a date is inputted, it…
-
Index/Match Question
Hi Smartsheet Community, I am trying to use INDEX/MATCH formula. It works for me for only reference to an another smartsheet. Is it possible to reference 2 smart sheet for INDEX and MATCH? I know I can do for reference 1 smart sheet = INDEX({reference 1 from smart sheet A}, MATCH(@row,{reference 1 from smartsheet A},0))…
-
Using join/collect to return task description when task is complete
Hi, I am trying to create a formula that returns a collection of tasks descriptions when the task is marked as 100% complete. The overall goal is to show, per project phase, what tasks have been completed to date. Here's what I have currently: =JOIN(COLLECT({Project Plan - EOL Asset Enterprise Range 1}, {Project Plan - EOL…
-
data synchronisation issues
Context: I have recently started testing Smartsheet, though the organisation I have joined has some established uses. So I am in a familiarisation and test phase. Talking to another user recently, he expressed concern about the Smartsheet user experience and data integrity / synchronisation. He had updated a cell in a…
-
Update request to be sent each time a given cell is triggered
I set up a workflow for an update request to be sent to a contact in a cell when 1 of 3 cell triggers occurs and 3 conditions are met. This workflow works fine. But.... I need to have the update request sent again if one of the 3 triggering cells is changed at any time. I cannot get it to send a 2nd time or multiple times…
-
Card view not displaying due dates
Hi folks. I have a sheet that has multiple dates columns on it (screen shot below). I want to display ONLY the due dates. However, the dates that are displayed are my "Week of" and "Check-In" dates. I'm wondering why I'm unable to change it and if there is a way to do so. Thanks!
-
Control Center - Project data Update
Hi, I am really new to control center. As suggested I followed the training . I have added all the new values in intake sheet .Using SCC blueprint i have created the new project. Templates , Reports , Project dashboards & portfolie dashboards working perfectly. About my problem , i would like to change project manager for…