Product questions?
Ask it here! The community's got your back.

Smartsheet Basics

Ask questions about the core Smartsheet application: Sheets, Forms, Reports, Dashboards, and more.

FILE UPLOAD ERROR
Is anyone else having trouble uploading files to a row or sheet?
Form Confirmation Email Subject Line Customization
Is it possible to modify the subject line of a form confirmation email? We would like to be able to add a field to the subject line so that when it is sent, it not only has the Smartsheet name, but the client name that email is referencing.
If column A status is X then tally column B
How do I do this? If my column A status (dropdown) is Pay Supplier I want it to then tally the column "amount due" with that status. Thanks
Form Confirmation Options
Is there a way under the Form Confirmation Options to show a confirmation message AND include a hyperlink to a Smartsheet? I see the box accepts HTML code, but it doesn't format correctly.
COUNTIFS with an OR statement
=COUNTIFS([Phase]:[Phase], OR(2", "3", "4"), [Project Status]:[Project Status], "green") When I input this formula I am getting a message back reading "#UNPARSEABLE". The part that I am struggling with is the OR statement. Is an OR statement possible within Countifs?
Workday formula
I want to insert the WORKDAY function into my formula. Where would be the correct location? =IF(ISBLANK([Acutal Start]@row), ([New Estimated End]3 + [\[Duration\]]@row), ([Acutal Start]@row + [\[Duration\]]@row))
Blank Rows in Gantt - Automatically get populated by start date
In Gantt format - I leave some rows blank to separate workstreams or buckets of work. But for whatever reason - Smartsheet goes and fills just the start date automatically in these row. I delete them, and then after I save, they come back again. They are harmless, but misleading and hurt the aesthetics of the chart. How…
In Form, "Clone" does not appear like in eAcademy video
In the eAcademy video on Forms, in Lesson 4, at -2:12 in the video, Crystal Morey explains that, after clicking "Forms" in the tool bar, and then clicking the "More..." link, that you can then click "Clone." In actuality, "Clone" does not appear. Is there something that wasn't explained that I am not doing, or is Crystal…
concatenation
On form B. I added this formula. I'm trying to concatenate all of values in a column named Request ID (in Form a) based on the value Description (in Form B) to the Vendor Number (Form A) =INDEX([{Request ID}]1 + [{Request ID}]999, MATCH(Description$9, {Vendor Number}, 0)) Form A Request ID Vendor Number 123 A 125 B 126 A…
Problems with nested IF/COUNTIF statement
Hi, I am trying to summarize in a parent row the information underneath. In the child rows, information is either inputted as N/A, or as a numeric value (%). For example, child rows are as follows: N/A N/A N/A 5% 10% I want the parent row to look at the child rows and determine if they are all N/A, in that case what should…

Popular Tags

Trending in Smartsheet Basics

Schedule Dates Minus 2 days Except Weekends
I'm trying to figure out a formula. I have a customer that requires a 2 day notice that my crew will be onsite to work. I have an automation set up to remind me to send the store an email 2 days prior. In my "Notify Store" column I have a formula for schedule date -2, but I don't know how to exclude weekends so that the…
PDF Generator Automation Attachments
I've set up an automation to generate a PDF when a row of data is submitted via a form. I have another automation to generate the PDF again each time data in the row changes. I am finding that the subsequent PDF attachment is replacing the first in attachments. Is there a way to have the subsequent PDF added as an…
Inform team on general sheet
Hi, Is there a way, now on a row but sheet level to inform the team whom the sheet has been shared with about modifications done to said sheet. E.g.; I have added locations to a locations column and would like to inform all sheet collaborators on it. Additionally I would like to ask some if moving forward to make a form on…

Help shape the future of Smartsheet.
Share your ideas and feature requests.

Watch video

Smartsheet Basics

Discussion List

Categories

Popular Tags