-
Year Planner Templates?
Does anyone know of a good template for a year-to-view planner? I'd like to also see a list of events too. I've seen it in the templates in MS Excel, but organised for school (mid-year to mid-year). I want to be able to track events coming up (training, exhibitions etc) and who attended. Thanks!
-
Row-level permissions?
I think I am asking the impossible here, but let's give it a go! I want to use Smartsheet for a career progression initiative, so the idea is to have a form where staff enter their details and ambitions. That's the easy bit, we can do that, The tricky bit is then allowing each member of the team to see and update their own…
-
ISBLANK question
Greetings, For the life of me I can't get this to work: This is the formula I have for the far right cells, I took out my test for ISBLANK, I can't get it to work: =IF(6500000 - [Total Earned]10 < 0, (6500000 - [Total Earned]10) * -1, (6500000 - [Total Earned]10) * -1) Can I get a hand with this? Thank you David
-
combined form
Hello,Is there a way to collect data automatically from google docs (word document not a form) to a spreadsheet? I have a questionnaire that each student need to fill in personally and I need that the personal data like name, age, phone No', will be collected automatically into a spreadsheet. thank you
-
Automatic Timeline Changes
Hello! Newbie here to Smartsheet. I am working on a project that requires a timeline of multiple items with deadlines that are dependent one each other (i.e. can't start phase 2 without completing phase 1). What formatting can I use to automatically push back phase 2 and 3 if phase 1 end date or start date changes?
-
SUM formula pulling 0 no matter what. Issue with using multiple formulas?
I'm attempting to have all resources check off each of the meetings they attend on a weekly basis and then pull in number of hours based off those responses. I've created a checkbox column for a meeting and then a number/text cell the right right. I wrote a formula saying, "if checked, populate with a 1.5, else keep null".…
-
Harvest (time tracking app) +Smartsheet integration
My organization uses Harvest for time and expense tracking. So i was excited to see that there was integration with Smartsheet in which i manage my portfolio. However currently it seems as if the integration only works as an export in one direction from Smartsheet to Harvest. Are there any plans to make this…
-
Sorting in a Sheet
When multiple users are in a sheet and 1 user sorts, everyone's sheet sorts. Is there any way to prevent that? Is there a change coming?
-
Summary in Gant
Hi there, is it possible to get a summary row in the gant like this: I need to know the sum of the lines for the week. Thanks Peter
-
Easier way to populate discussions?
One of the ways we use SmartSheet is to help us manage parts that experiencing a supply/demand imbalance. Because SS doesn't have dynamic updating (i.e. vlookup), we had to structure the tables with a static snapshot on why the part made the list. For example, number of past due orders, inventory levels, etc. Once a part…
