Hello, I have a formula I am using on one sheet. The sheet is named "Mark" since he is the Point Person. =COUNTIFS([First Contact Year]:[First Contact Year], "2020", [First Contact Month]:[First Conta…
I have a sheet where i am tracking multiple different tasks for completion. i am attempting to create an (Overall status) once a few key items are marked completed, and or box is checked. Can someone …
I faced this issue when three and more files are attached to the row. In this case, their numbering becomes incorrect. For example, the latest version of the file can be marked as V2 or V3 whereas it …
Trying to figure why this isn't working...the first two formulas seems to work but adding the third gives me the #INCORRECT error...Please let me know what I did wrong? =IF(ISBLANK([1st PRODUCT_OWNER …
Team, I know you can do it. I have two databases (same structure, different information), but I need a third that consolidates the two previous. If anything gets added in the sources, it needs to be a…
Hi, I am trying to find out the best way to work with smartsheet in a particular scenario. I have project smartsheets that outline project milestones, and tasks within. This sheet is shared externally…
Are you able to format only certain text/characters with an individual cell, or does formatting apply to all the text/characters within a cell? If I cannot format only certain characters, this would b…
I am using another sheet for the lookup_table. The other sheets basically has the currencies and the rates of each currency. What I want to do in the sheet where the function is; basically once a row …
Hi, I'm new to Smartsheet - I have created a Task list and want to create parent and child rows in a task list, but the indent/outdent buttons are shaded out and the shortcuts (Ctrl ] ) don't do anyth…
Hi Community, I am in the process of creating a new Team workflow and I would really appreciate to discover how to easily import Trello Custom Fields into Smartsheet. I am aware of the Trello import p…
