Hello! I'm trying to use this if statement: =IF(OR([1]67:[30]67 = "R13"), "500", "") But it's not working when I want it to check the whole row ([1]67 through [30]67) for R13. Is there another way for…
I have an existing sheet which contains a schedule of annually recurring tasks. I saved a copy to create the new year's sheet and now need to update the dates. Is there an automated way to do this?
Hello, Other areas of the business are exploring the use of smartsheet and they would like to connect our existing analytics tool (spotfire) to use smartsheet as a data source. I've followed: http://s…
I have a sheet that I inherited and it has all kinds of fields used for statistic reporting. I want to edit the sheet, but don't know what formulas on this or other sheets I might break if I edit it. …
Thanks in advance for reading this :) I have multiple inventory sheets, each has a column with a formula to flag duplicates within a specific column: =IF(ISBLANK([Serial Number]1), "blank", IF(COUNTIF…
Hello, I have read the forms with the “VLOOKUP” and “LOOKUP” functions. I am new to smart sheet, but not to excel formulas. I have an associate inspecting carts for wear and tear items, this is workin…
hello all, my percentages are going int minus or over 100% . i currently use this formula , can anyone help =(TODAY() - [Start Date]5) / ([End Date]5 - [Start Date]5) regards Carl
Hi, I am looking into utilizing a ITIL related priority matrix approach to populate a Priority. The Priority levels column's cell would have values P1, P2, P3, P4, P5. The formula needed in the Priori…
I have a report that I have published to a dashboard/site. I need the users to be able click on the Widget in the site to open the report, mainly so they can view comments on the rows in the reports. …
First post. Love Smartsheet! Did some searching, but came up blank.... I'm typing away managing my first big project in Smartsheet and am adding a lot of comments. I'm clicking the mouse to bring up t…
