- Reports not listing entries when it should
Hi there, We manage store fitouts. With every project, the sheets are identical. I have created 16 sheets to manage 16 projects. I have just recently added few rows, all identical, on all 16 sheets. When I run reports, it does list certain rows (newly created). Puzzled, I simplified the report to the bare minimum: I now…
- 创建公式内容
Hello, I have a requirement to calculate the remaining shelf life of products at the time of receiving in percentage. My formula is: (Production date + Expiry date) / (Expiry date - Delivery date). The end result should be a percentage. Can anyone help me to achieve this? Regards, Jasmine
- 创建公式内容
Hello, I have a requirement to create the below formula in smartsheet. Please help. If short shelf life is between 40% to 59%, then discount is 5% on the invoiced amount, If short shelf life is between 30%– 39%, then discount is 15% on the invoiced amount, If short shelf life is between 20 – 29%, then discount is 40% on…
- Calculating a day from a date
I've got a column (called "Dates") formatted as dates. I would like the adjacent column to show the day of the week that date falls on. Using the formula =text((Date1), "dddd") brings back an #unparseable error in the cell. I've tried using brackets instead of parenthesis but it hasn't worked. I must be messing up the…
- Showing multiple true checkboxes as joined or concatenated text in another column
I have a volunteer submission form which has about 10 columns that exist as just checkboxes on/off - each of these relate to a conference work area and volunteers often select multiple. To easily view the data for a single person/row without tons of scrolling and looking up and down at column titles, I want to aggregate…
- Nested IF(ISBLANK & Date Columns w/Progress Bar
Hi Everyone! I would like to know if you are able to use date columns when automating a progress bar. Basically dates are entered as product moves to a new stage in the process. As the dates fill in, the progress bar fills as well. I've used nested IF formulas for automating a progress bar but, for whatever reason... Im…
- Dashboard Color
任何计划s in the future for letting us update the dashboard background color to any color we'd like? I'd love to be able to use black for dashboard backgrounds, as well as the backgrounds of the widgets, so that when on TV sets around the office, graphs are floating in black instead of a white background.
- Scanning a Barcode
Does anyone currently know if smartsheet is capable of capturing data from a bar code?
- Time of Day
I have seen several forums related to Time of Day as a column option. This appears to be ongoing for nearly (4) years as a feature enhancement. Can someone provide an update and a simple workaround (not a long-winded formula option)?
- COUNTIF Formula for when a cell contains a specific word/phrase?
I'm trying to create a formula that allows me to count the number of times the word "Postcard", for example, appears in a list in a column. I am referencing a column in another sheet to do so. However, nothing I've tried works. My instinct was to try =COUNTIF({2018 Open Enrollment Feedback Range 1}, "Postcard"). However,…
