-
Adding Time Values
New to smart sheet but couldn't find an answer to this question! Is there a way to add several time values to a total (ex. :15 + :15 = :30)? My goal is to sum all overtime minutes worked during the week into a running yearly total. On my spreadsheet I have a Total YTD Hours Column, A column for each day of the week that…
-
IF Statement for a whole row
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 me to do this statement? Thank you!!!
-
Increment dates for new year
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?
-
Issues connecting to Smartsheets
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://smartsheet-platform.github.io/odbc-docs/ and successfully installed the ODBC smartsheet driver, created a DSN, successfully…
-
Is there a way to tell if a cell is used in another formula or not?
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. Is there a way to know if a cell is used in a formula somewhere else? Thanks, Carolyn
-
cross-sheet duplicate search
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([Serial Number]:[Serial Number], [Serial Number]1) > 1, "yes", "no")) Form there, I apply some simple conditional…
-
Use a form to lookup sheet data that and add content to it
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 working well with check boxes and the photo attachment is awesome to have. Next step is the associate that repairs the cart, I…
-
Percentages are showing minus numbers -120%
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
-
Impact with Urgency equals Priority
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 Priority column would output an appropriate priority level based on specified combination of values from two other columns: Impact…
-
Reports Published To A Site
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. I need them to be able to do this without them being granted access to the source sheets. Any assistance or direction on…