-
Countdown from today not working
I am having the hardest time using any kind of formula...whenever I type them in I get the unparsed error. I am trying to do a countdown from today to an end date but no dice. I find the explanations on here for how functions work aren't really helpful for me. I have turned on and off the duration function, it gave me a…
-
Using SUMIF to provide value of orders from this week only
Hi, I am trying to get a formula to sum the total value of orders invoiced this week. The formula i have tried is below, but returns '0' as the value. =SUMIF({Completion Date}, {Completion Date} = WEEKNUMBER(TODAY()), {Order Value}) The sheet references are to single columns titled 'Completion Date' and 'Order Value'…
-
Can you have a character limit in a Web Form text box?
Is it possible to have a character limit in a text box within a Web Form? We've limited the number of lines to three, but would rather limit to a specific character count. Appreciate any insight!
-
Formula(s) for calculating past due items on a construction punch list.
I'm creating a simple punch list template and would like to add some date calculating functions to it but I'm very unfamiliar with creating date formulas. I'm attaching a screen shot of this rough template with a sample line already entered. I would like to create a formula that will tell me how many days past due items…
-
the end date and the gant chart date is not matching
Any body has a problem similar to this: I set the end date at 2018, but the gantt chart showing a 2019 ?
-
Multi Formula/Sheet Help
Hi Been struggling with this for ages, I can get the two elements of this formula to work separately but not together - I hope the below makes sense! :) I am trying to get a formula to: A) Search a column on another sheet to see if a reference number is present The below works but gives me the total count…
-
Community Template Section
I have had a quick search and nothing has come up. What are the communities thoughts on a community driven template folder for sharing above what Smartsheet provide. I have read someone wanting LPM (Legal Project Management) templates and Smartsheet are submitting the request. As an alternative would a community template…
-
Analysis of information
Hello experts! I need your help to figure out what's the best way to create a report/dashboard? I have a total of 130 SmartSheets. I need to combine all of them in one. I am not sure if a report and or a dashboard would be the best way. All the columns are the same in ea. sheet, but the second columns (Task Name) What…
-
return list from another sheet
Anyone able to offer some help on the formula below - trying to return a list of information relative to an employee ID number to a column. There will be several matches per ID, e.g. Matt worked item 1.. 2... 3.. and 7. I want to return the information relative to that ID for those entries. Thanks in advance!…
-
Date changes to tomorrow after 5pm
Hello, I have been trying to find a work around for an issue I am having on sheet we use. We are currently using a sheet for employees to submit when they check out and check in equipment via a form. We were using the auto created date column to run reports on what equipment were checked out vs. available. We discovered…