functionality
Discussion List
- I wanted to COUNTIF the number of cells that start with specific four letters in a column of a reference sheet. I used the formula below and it returns zero. =COUNTIF({Reference Sheet}, "ABCD") Is the…
- I currently have all the individuals formulas i'm looking for however I'm having trouble combining them into one formula that I can embed in a cell. I know I can create a workflow automation to get th…
- Hi. I need to collect feedback about several programs using a form. The form should include the same questions for each program. Any ideas about workarounds that allow me to use a field several times …
- I have a grid sheet which captures status date and status narrative text as columns. For each new status date, a new row is added to the grid sheet. How can I display the most recent status narrative …
- I need to share a workspace with some users with the exception of a few sheets that have confidential information. Is there a way to share everything except those sheets? There doesn't seem to be a wa…
- Hi again, I am trying to write the following formula and am not getting the answer I am looking for. My goal is to count the late items in a task sheet. This require two parameters to be met. the date…
- Hello! I am wanting to do an averageifs statement, but it does not seem that is supported. Is there another way that I can calculate an average based off fitting two different criteria? Right now, I h…
- Good morning, I'm creating a form that I'd like to be able to save the responses as a PDF document. As far as I can tell, the only way to see submitted forms is through the sheet itself - not in any "…
- Hey there! I am working with a large archival destination sheet: We haven't hit 20k rows YET, but it'll probably be coming this year. The automation moves Completed rows from an active tracking sheet …
- Hi all, I am pretty new to Smartsheet and will need your help to build a dashboard. What is the best practice to create one? GRID I have multiple salespeople in my team, each of them have their own gr…
