-
IF AND OR not working properly, last IF not triggering anything
Please help me figure out why this is not working: =IF([% Complete]@row = 1, "Completed", IF(AND([Start Date]@row <= TODAY(60), [% Complete]@row = 0), "Not Started", IF(AND(NOT(ISBLANK([Start Date]@row )), NOT(ISBLANK([% Complete]@row ))), "In Progress", IF(AND([Start Date]@row >= TODAY(61), [% Complete]@row = 0),…
-
In Smartsheet, how do I lookup and return different values from sheet 1 to Sheet 2 in one cell?
Hello, In Smartsheet, if I want lookup and return different values from sheet 1 (Test-IMS) to Sheet 2 (Test 2-SOS) in one cell, what should I use? Note: The two values from Sheet 1 will be different. Let me know if you have questions or I need to clarify more. Thanks,
-
Trying to create a new sheet in a Workspace is throwing an unexpected exception C# SDK
I am trying to create a new Sheet in a specific Workspace using the Smartsheet SDK for C# and I keep getting an unexpected exception The statement above compiles just fine. The Workspace ID (wkspID in the code) is correct. I can create the Sheet just fine locally but the sheet does not have an ID until it is created in…
-
Parent/ Grandparent Cell Value
Hello- I am looking for a way to make every row return the same value as the highest level of its hierarchy (usually just children and grandchildren). I want it to report the top row in a column. In this example, I want all of these rows to return the value "Top Line" in a column.
-
Force refresh of page if User uses back button on Browser
I would like to find out how I can force a page refresh if a user press the back arro / button on their browser
-
Dynamic View Missing
The Dynamic View button is no longer in the ribbon of my worksheets. The leads indicating where it can be (Launcher icon etc.) are missing. Even if changing the view from Grid to Table, I don't have it as an additional item on the "More" dropdown. I have always had access to it. Where has it gone to?
-
find manually entered duplicate lines
I have a sheet that contains practice-name, practice-seq,and coach-id. I have somehow added multiple exact duplicates. there are 8500 entries so its hard to find them….is there a report I can run to just show eact dups?
-
Sumifs formula shows wrong value
Hi., I have two sheets: one is the Master Sheet, where multiple people enter and update their status, and the other is a Report Sheet, which summarizes the data using a SUMIFS formula. I’ve been using this setup and formula for about two years without any issues. However, for the past two days, the summary sheet has been…
-
Feature request: How to merge cells in Smartsheet
merge data into cells like excel does in a user friendly way similar to this article. https://www.projectwidgets.com/how-to-merge-cells-in-smartsheet/
-
Access to Smartsheet report not working as expected
Hi, I have a report which is generated out of 6 different sheets. To all the other 6 Sheets, I have given a person "View access" and to the report created out of 6 Sheet, I have given "Editor - Cannot share" access. Still the person is not able to see the report. Then I have given "Admin" access as well, but still that…