-
Multiple Calendars
Does Smart Sheet support multiple calendars similar to Projects where you can setup custom work days? If it doesn't how can I assign separate working days for different groups?
-
Exported data does not align with comments tab and primary tab
I am exporting data from Smartsheet to Excel and the Comments tab row descriptor doesn't align to the correct line item it is commenting on in the previous tab. Is this something Smartsheet can fix as part of the export to Excel process? Otherwise, you cannot tell what comment belongs to what data row, this then causes…
-
Where did the Cisco Webex Teams integration go?
I have been using the Cisco Webex Teams Integration for years to notify me of changes within a sheet. This stopped working on 12/9 and I have not been unable to resolve it. Smartsheets list of integrations no longer shows anything for Cisco or Webex. Is this a permanent or temporary issue? Thanks
-
Formula not working (UNPARSEABLE)
I have the following formula that is not working. =IF(AND([TOTAL %]6 > 0, [TOTAL %]6 <= 0.1), "YELLOW" , IF(AND([TOTAL %]6 <= 0, [TOTAL%]6 > -0.1), "GREEN", IF([TOTAL %]6 <- 0.1, "PURPLE", IF([TOTAL %]6 > 0.1,"RED" The return I get is (UNPARSEABLE) Please advise if you can find the error in my formula. Regards, Derrick…
-
AVERAGEIF formula
I'm trying to get the average of the # of weeks it takes from an NDA to LOI for a particular team (Koala). I am using the formula: =AVERAGEIF([Business Unit]:[Business Unit], "Koala", [Weeks NDA to LOI]@row) I'm stumped. Thanks for your help!
-
Version Control of Project Plans/Sheets?
Hello, I am wondering if there is a way in Smartsheet to version control the sheets. Basically, we are using each sheet as an individual project plan. However, as projects progress, the plan will (usually) slip and/or have to be updated, so we need to amend it. Since there seems to be no way in Smartsheet to baseline the…
-
Dashboard Graph Widget Question
Hi! Is it possible to create a graph with two graph legends? For example, for a service type showing a graph for volume of work and revenue? Thanks!
-
Do share permissions follow when moving from Sheets to Workspace?
Hi team - I'm just wondering if you have a bunch of sheets/reports/dashboards in the SHEETS directory of Smartsheet, that are shared to various people, and move those items into a WORKSPACE, do the permissions from SHEETS follow? Or will only those folks in the WORKSPACE permissions able to access those items? Will I then…
-
Email provider, not compatible
We use Microsoft Outlook 2016 desktop version and do not have 365. We also use Ionos webmail. Any suggestions on attaching emails without 1) saving the email as a PDF and adding an attachment or 2) copying and pasting the email contents into the comments?
-
Calculation of the number of actions per contact for a multi-contact cell
Hello, I am new to using Smartsheet and I want to extract the number of cells that refer to a contact. This may seem simple, but Smartsheet only takes into account the first contact mentioned in a cell, if it has several. Example for the year 2020: How many times was the contact "e-mail address" mentioned? -->…
