-
Countif a name from a list of multiple names
Greetings- I need formula help to count a name EMMA that is selected from a drop-down that has other names selected as well. Basically I need to county if Emma's name is listed in the Education Naturalist column that has other names included in the same cell. If I use =COUNTIF({Program Survey Range 1}, "Emma") it will only…
-
Assignee reporting for all tasks during specific date ranges
I have been trying to create a report that shows all the tasks my team have on each week. I found some guidance in a community post about setting filters based on the start and end date. However I have found this doesn’t provide quite what I need so I was wondering if someone might be able to help me. Basically, I want to…
-
how to set up info sheet to feed into Resource Management
I have entered this data and am using it as a way to track allocations across different projects. The different projects are indicated by the different WRT #s in column 1. I need to then summarize the last 2 columns by WRT #, which I've done here in a report. I am wanting to add some type of flag or conditional formatting…
-
Registered Charity in UK
We've been using Smartsheet for 2 years as a registered charity and I notice that a discount is available. How do we access this as an existing user?
-
NEW! Wider dashboard canvases and dashboard zoom
Hi Community, Wider dashboard canvases and dashboard zoom are now available! Present more content with less scrolling and elegantly visualize your work on widescreen displays. To convert a standard-size canvas to a wide one, open your standard-size dashboard in edit mode and click the expand icon. We’ve also introduced…
-
How to dynamically sum two different rows, same shet.
I can't view my post so i'm posting again sorry smartsheet's!…anyways, HELLO INTERWEBS HUMANS!!!, thank you for taking the time to read my word salad. What i'm creating: Time tracking workspace for around 60 employees. Has a lander page that accepts form submissions (clock-in /clock-out) (separate rows). User accepts…
-
Multiple sheets
Hi! I have one sheet set up where we can input a bunch of different data. Is there a way to input the different data but have them feed to their own sheets instead of populating on a single sheet and having to filter through rows? Hopefully that makes sense!
-
Add Parent Link to Smart sheet/JIRA connector
Currently, the Smartsheet/Jira Connector is not populating the Parent Link, as Jira moved all Epic Link into Parent Link. With Parent Link, this allows user to be able to calculate the percentage of the completion of the Epic, so anything and everything can fit under it. There is a bug or no support as smartsheet should be…
-
Unable to Convert to Column Formula
Using this formula Smartsheet isn't letting me convert to a column formula: =[Material Received]@row - [Purchase Date]@row - [Lead Time (days)]@row
-
DocuSign Mapping Glitch?
I have templates connected to my Smartsheet process where I create the mapping and use 2 columns with emails as the contacts to send out envelopes - but all of a sudden today the mapping part won't bring up these 2 columns for me to use as the emails for the contact portion when creating the DocuSign mapping? It pulls up…
