Hello, I have a sheet where I can see budget, actual and variance for my project budget. So column 1 is january budget, column 2 january actual and column 3 january variance, and so on. All I want to is to create a line-type chart for my dashboard where I can see the comparison between the budget and actual numbers for…
Is there a way for a workspace to alert the individuals that have been shared to that workspace when a new sheet is created or added to the workspace?
Hi there! I'm no excel or Smartsheet formula wiz but I'm hoping someone here can help me figure out a way to do the following: I'd like an auto-populated number to appear in a row when the "Estimate" box is checked. There will be some rows where estimate is not checked and therefore I don't want to dedicate a row to a…
I have a sheet. I save it with Display Summary Tasks disabled. I create a template from sheet. Any new sheets using this template now have "Display Summary Tasks" enabled. Am I doing something wrong or do I need to file a feature request?
Hi All, I'm considering using Smartsheet for a somewhat complicated process and I could use some help thinking through how this might work. I have the basics listed below but I would appreciate if the experts here could let me know if you see any issues or improvements. Sorry for the long post. Thank you! Need: Need to…
I'm looking to count the number of punches at various rec centers within the last 7 days. Rec centers have dropdowns with locations. Punches is a numeric value with a daily total. Each center has a daily total. I have a separate sheet for calculations. I'm looking for a formula related to each center to count the number of…
I'm trying to write a formula in my driver sheet that will search for an employee ID number in the completion sheet and return the text from a column within the completion sheet. I wrote the following but it returns a #NOMATCH value if the employee ID is not listed in the completion sheet. I'd also like for it to return a…
I have been asked to look at Airtable. Currently our team uses smartsheet. Our team is leaning towards Airtable due to its easy and customized views, plus ability for executives and stakeholder to create their customized views. How good is airtable compared to smartsheet How good is airtable for work collaboration - so…
IF Type = Project join Type+ID+"-"+PMO Project Name If Type = Request join Type+ID+"-"+Request Name I've tried this a couple of ways - if I select Request - it comes up as Request1000-RequestName If I select Request then it blanks out. instead of Project1000-ProjectName Formula =IF(Type@row = "Rqst", JOIN(Type@row + [Rqst…