-
Adding Image to Cell from gdrive URL automatically using Python & Smartsheet API
Hi All, I am currently trying to automatically adding image into a cell in smartsheet using Smartsheet API and Python. So, we have two column : Column A containing image URL Column B where we want to add the image from gdrive URL I have hundred rows, meaning we have hundreds cell on column B to add image from column A. I…
-
Future Date Calculation to a nth Day of Month
Hello, looking for help with this formula. Need to calculate a future date based on the [End Date] Conditions: (1) Only display a future date if [Ord Amt] is true; (2) Future date to be one month earlier then month of [End Date] unless; (3) [End Date] month = January, then Future date is to be December and one year earlier…
-
Multi-Level Blueprint/Navigation to Upper Level Blueprint
Hello I have a PMO system with three different blueprints. For simplicity we'll call them: Blueprint Level 1 (Top Level) = Client Blueprint 2 (Mid Level)= Program Blueprint 3 (Bottom Level)= Project When I provision a new project I need to be able to navigate upstream to Level 2/Program. Right now the process is to…
-
Generic Function based on the above row
Hi Guys, I am introducing a new column titled 'Delta' where each cell's value relies on the value of the cell directly above it, as illustrated below: in row#15, I have this code: =IF((ISBLANK([ColumnA]@row)), Delta14, [ColumnA]@row - [ColumnB]@row + Delta14) in row#16 I have this code: =IF((ISBLANK([ColumnA]@row)),…
-
Tracking
I'm looking to create a smartsheet that can track our heated bags. So What I'm looking to do is have the employee scan the qr code that I will create and it will bring them to a form they will fill out, then that form will generate with all the employees information for me to see in one spot on smartsheet. I do not want…
-
Allow color and logo to be specified for folders as it is for workspaces
I submitted this a couple of years ago using the old form submission but am adding it here as well as I still very want this. The situation Workspaces allow us to specify the workspace colors and logo: This changes the color of the stripe at the top and adds a logo to each sheet, dashboard, report, and form. My team manage…
-
Facilities management tracker - tracking services done in each month
Hi all, i am working in the FM sector and i am managing a clients servicing for many of their retail stores. i have built a tracker with numerous formulas in. Each service/line has a ‘Date of last inspection” column and a “Date of next inspection” column drived by the frequency of the visit in another column with a simple…
-
Custom Colors for Sheets
While it is wonderful that we now have the ability for custom colors on Dashboards, it would be truly helpful to also have this same ability in Sheets. It would be really helpful for some of our projects because our district uses certain colors to call attention to various district initiatives or our district instructional…
-
One Conditional Formatting Rule Not Taking Priority
I apply a similar strategy of conditional formatting to a lot of sheets and don't usually have any issues, but on this one sheet, I have a rule that's listed above the others, but it's not taking precedent over the other formatting rules and I'm not understanding why. I have a cascade of blue colors to denote "header"…
-
Glad I found the Education group
I just clicked the "Follow" button for this group. It will be interesting to learn how others navigate these waters using Smartsheet. We have a large team here, me and my Manager. So I am looking forward to these learning any tips and tricks in the Education realm.