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'…
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!
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…
Any body has a problem similar to this: I set the end date at 2018, but the gantt chart showing a 2019 ?
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…
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…
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…
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!…
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…
Since smart sheet update new version. We are used to able to look details with Grid view.. Now we have to review with grid view and then go to list view and able to see detail...it makes more longer time operate n more comfusion..please we prefer before version smart sheet
