-
Creating a chart from non numeric values
I have created a form for users to fill out based on their experiences with a certain process. They will be asked questions such as "were instructions clear" and they can answer Very Clear, Somewhat Clear, Unclear. I was trying to create a pie chart from this sheet that shows how many users selected Very Clear vs. Somewhat…
-
Sales pipeline evolution metrics and dashboarding
I own a Smartsheet that captures all of the sales opportunities one per row and each marked with a pre-defined specific stage of the opportunity (investigation, qualification, archive, execution, etc). These will naturally evolve thru the sales funnel and individual smartsheet contributors will update the stage shortly…
-
Best Practices for managing 60+ projects in Smartsheet
Hello, I am a fairly new user of Smartsheet and have recently started at a construction company as a project manager where we design manufacture and erect large steel buildings for rural and industrial use. (From farm sheds through to aircraft hangers and fabrication workshops.) We have up to 70 projects active at any one…
-
If date is less than, greater than, or blank formula.
I am creating a formula that will display Completed, Upcoming, or Prerecorded based on the dates in Column 2021 Session Dates. When I use the formula below, any row with no date comes back as Completed even though I have added the IF ISBLANK formula to output Prerecorded. I don't get an error in the field, just not getting…
-
A formula pulling Time from a System-Generated column does not stay consistent. Please help!
I am using a formula to pull the time from a system-generated column using Created (Date). The formula is =RIGHT(Created@row, 8). A majority of the time is accurately pulls that correct information but other times it is off by two hours. For example, the screenshot is showing it accurately. But it will randomly switch to…
-
Choosing a Task List vs a Project
So, I have a question that on the surface might have obvious answers but want to think through the potential implications for choosing a Task List vs a Project. In theory a Project should have a defined start and finish for all tasks. A Task List essentially becomes a "to do" list. Tell me what I might be missing please.…
-
What function can recognize a name in a multidrop down list and reference a corresponding column?
I am trying to create a sheet with the purpose of allowing a supervisor to see what crew members are currently busy and what days. This is Sheet B, while Sheet A is the list of projects and all corresponding details, like dates and crew members. I am doing this with an "Status" column in Sheet B, which scans the crews of…
-
Annual Calendar Template by Day multi activities
Hi, the default set up for the Annual Calendar template seems to only anticipate one activity per day. How can I input multiple Activities per date without adding a new row and duplicating the day of the week and date?
-
Trying to delete a large number of rows trough API
Hi I am using the Node JS SDK to delete the content from a sheet. It works fine but for a lot of rows it fails (I have tested with a minimun of 1000). I get an error that says that the request is to large for the server. I understand whats happening, but I was wondering if there is another way to clear a sheet using the…
-
Calculate Date based on Criteria in Two Cells
I need to write a formula to check a cell for a size (Small, Medium, or Large) and calculate a start date from a go-live date in another cell. If the size is small, it's 14 days earlier, if it is medium, it is 21 days earlier and if large 28 days earlier. I've go this as my starting point: =IF([Size]@row,…