-
Adding detailed information to a row / task
I have a column set up as "Notes" that I'm using to record all the details of that task. Eg., I'm running a software project so I need more info - it's a new feature, what are the features, what did the customer request, how do we intend to implement it? I.e., detailed info rather than simple notes etc. I can go to Card…
-
More than 2 actions following an approval
Is it possible to have more than 2 actions after an approval in the same workflow? We have a sheet that requires the tasks to be approved by a member of leadership. If it is approved I need the project lead to get an alert, the date to be recorded, and the status to be changed. I would prefer not to have multiple…
-
Creating a new smartsheet Project-type-sheet from scratch with the API
Hello. Trying to create a new Project-type-sheet with the API, and would like to designate everything about it the way I want in code, so NOT from a template. It appears there is no way to do this with the API, that it simply has no syntax for creating a gantt-enabled project sheet. Is this true? But next question - if you…
-
Using Countif in place of Autonumber - formatting question!
I'm creating a ticketing system with multiple prefixes. Because of the multiple prefixes on one sheet, II opted to create a nested formula to number the tickets based on the various types of requests. Here is the formula: =VLOOKUP([Request Type]@row, {Ticket Assignment}, 2, false) + (COUNTIFS([Request Type]$1:[Request…
-
Report with image of attachments
Hi Everyone, Is there a way to create a report that shows the image of the attachments? We have a quality control sheet that new items get added through a form along with a picture. I would like to create a report that can show the picture next to the fields associated the punch list item. Another way would be to export…
-
Rich Formatting On "Summary Sheet"
I'm stuck! I am effectively trying to create a Sheet Summary report with conditional formatting, however, I understand that is not an available feature. Instead, I am trying to create a sheet (not a report) with formulas that pull from multiple sheets and can be formatted. I have 20-30 real estate development/construction…
-
Cell Linking - Updating Source Sheet
Not sure if this has been answered before and if so, apologies, I could not find anything relevant. My team has been trying to link from a 'schedule' sheet out to smaller sheets so that we no longer have to manually update the smaller sheets. Unfortunately, we have found that whenever we need to update the linked cells in…
-
Multiple Results Formula
Hello! everyone I was wondering if someone could help me with a formula We have an audit schedule based on 5 years and I currently have the "Count" essentially telling me how many times a topic was audited in the past 5 years. What I would like to generate is - "in which years was the exact same topic audited?" which would…
-
Need Help Sorting & Grouping "Day" Data By "Week"
I'm brand new to functions and Smartsheets in general so please bear with me as I attempt to learn with you all. I've read over the functions documentation and to be honest, it's a little over my head. I'm trying to suss out a step by step otherwise I get lost. But I'm hoping I'll get there eventually! Here's the nuts of…
-
Burndown Chart
I would like to use a burndown chart to track tasks of projects. Is there the template for burndown chart on Smartsheet?
