Sheets
Discussion List
- Hello all you wonderful SmartSheet users I am trying to find a way to represent a repeated task and the associated information (Start /finish Dates, Status, % complete) from the first time this task i…
- My project contains multiple sheets that need to be summarize. Each sheet has a sheet summary but since my data spans across multiple sheets, I need to combine the calculated fields in my sheet summar…
- I have an IF equation that is working fine for me, however, I would like for anything that is past due to be "Red" in the task health bar. Right now, because I have "Grey" as the first clause even if …
- Hi, I have a column where a manager gives a timeframe of '1 week', '2 weeks' or '1 month' to complete a given task from their visit - how do I get smartsheets to generate a new date through a formula …
- I have a column asking three questions with the option to check one or all. Is there a formula to test if all checkboxes in one cell have been checked? I would like to apply the fomula to a symobol co…
Implement 'partial match' search on drop-down lists in Dynamic View so it works in same way as sheet
in a sheet - a drop-down list column with allow multiple values selected offers a 'partial match' text search capability so that typing words in the middle of a text string will result in a shortlist …- This is a follow question - reposting for visibility. While my original question was answered, I'm now having trouble with the formula. This formula seems to be working, however I am expecting it to r…
- Hi, I have six sheets with an identical setup. I want to be able to summarize how much Effort each person has been assigned for all the sheets. For example, Bugs Bunny may have 12 hours assigned in Sh…
- I have created a workspace for my team where everyone has a sheet to enter projects and I have them all connected to a dashboard using reports and formulas. These sheets are just for small projects, b…
- Hello everyone, I have a fairly large sheet (~5000 rows). I have one column whose value gets changed based on data from another column within the sheet. The source column is a country code column and …
