-
Hierarchical numbering patterns?
Anyone with experience setting up hierarchical numbering schemes? I want to add a column that is hierarchically auto-numbered such that child rows are added to the numbering scheme as increased decimal points. For example 1. Row 1 --1.1 sub item of row 1 ---1.1.1 sub item of row 1.1 ---1.1.2 sub item of row 1.1 ---1.1.3…
-
COUNTIFS function with two criteria
Hi all! I'm currently trying to count how many red entries (in the "Puri Safety" column) are in the month of June (using the "Created" column). I'm trying to use the following formula: =COUNTIFS(Created:Created, IFERROR(MONTH(@cell), 0) = 6, [Puri Safety]:[Puri Safety], "Red") However, it returns a value of zero... what…
-
Created time is displaying as Pacific Time in Dashboard
I have created a dashboard and added a report to the dashboard. In the published dashboard, the "Created" time is displaying as 3 hours earlier than what the report and Smartsheet is showing. How can I get the published dashboard report to display the correct timezone as is seen in the actual report and Smartsheet?
-
Is there a way to alphabetically sort collaborators and shared users (when emailing a sheet)?
I have sheets that I want to notify a few people of changes. When I use the email to shared users function it will list all users shared to the workspace first and also users shared to the sheet. It would be helpful to see the list in name alphabetical order so I know I have selected the correct people. I find myself…
-
Automation Workflow broken?
Has anyone experiencing any "Request for Approval" workflow issue? e.g. approval request goes though a workflow that is NOT as defined - the COO is receiving purchase request that does NOT required his approval. Any help is appreciated.
-
Display Logo at the sheet level
Hi, is there a possibility to display 2 logos at the sheet level? I know that I can include a logo image to the workspace and that will replace the "smartsheet" logo from all files within that workspace. But what I am trying to do is to personalise at the sheet level because within the same workspace I have sheets that…
-
How do we improve formatting such as merged cells?
What other options do we have to format the sheet better, perhaps even in sections? Merging some cells will help get rid of the lines and make things look better spacing wise.
-
Limit the use of a dropdown selection to only a single row in a column
Hello, I've developed a sheet that our Project Manager use to generate a Certificate based on a number of criteria. So the Certifcate (a dashboard) pulls the correct data from multiple sources, the user needs to simply select "YES" in the appropriate row per the below screen shot. Can anyone suggest a way that limits only…
-
How can I count dates in the past/future?
Hi, I'm trying to create a formula that counts certain actions in a column based on their date. Say, if there are three dates: 5/15/2020, 5/20/2020, and 5/30/2020, I want to be able to know which ones are in the future and which ones are in the past. In this case, the counter should return 2 dates in the past and 1 date in…
-
Remove Link but Keep the data
Hi, Is there to keep the previous data if the Reference if deleted. I have this formula =IF(vlookup(referencetoanotherSheer)=x, True). But if the other Sheet is deleted, I want it to maintain the value instead of showing #REF