-
If/And Statement
I'd like to write a formula based on Start Date and End Date Columns: If Start Date is less than or equal to today and End Date is greater than today or blank, I want "In Progress" If Start Date is less than or equal to today and the End Date is less than or equal to today, "Complete" If Start Date is greater than today or…
-
Add ANOTHER Attachment Column?
Is there a way to have more than one column for attachments? I know multiple attachments can go into the standard column, however, I was looking to label different columns for different attachment types. Thanks!
-
Forms
I've created a form - but where is the actual sheet for this form that I have created? Where do I find it? Have searched for it under every section, no success.
-
Looking for help with a SUMIFS statement
Good morning! Looking for some help with the below SUMIFS statement. I'm getting a couple different errors returned depending on my mood. The challenge is the final criteron where I want to check a cell and return true if the cell date is within a certain range. =SUMIFS([AC Size]:[AC Size], State:State, "MA", [PTO Forecast…
-
Sharing Sheets Automatically
Hi, Could we share sheets with new contacts automatically? I have a form and in this form I need to add a new contact, by adding his email. So a new contact is created in smartsheet automatically, but I need once this contact is added or when the form is submitted I need to share the sheet with him automatically, without…
-
Tracking time in forms
Good afternoon, We are creating a form/sheet to track our deliveries to job sites. We want our driver to be able to log the time he arrives on site and the time he leaves. Is there a time feature we can use for forms? Thanks
-
Controlling numbers on axis
Hi I see from the discussion boards about this time last year that you guys were going to enable users to specify numbers in graph axis on a dash board - I only need whole numbers - I've tried today and still can't do it. Any tips?
-
Sorting selection of Rows
Hi there, I'm struggling to just sort the columns without it selecting the whole row? I've tried highlighting a selection > right-click > row-actions > sort-row, but this selects the whole row as well and I'd just like to sort the columns individually in A-Z. Thanks, Subin
-
Copy of My Responses
Hi there: I have a client who completed a form, but it would allow him to submit his form with the "send me a copy of my responses" selected. He deselected and the form did come through. How can I send him a copy of his responses? I would like it to be in the same format as if he had selected the button vs an export to…
-
% complete report for multiple projects
I am trying to build a report that shows % complete, by project, across multiple projects (eg, Proj 1 = 50%, Proj 2 = 75%, Proj 3 = 10%) in one report view/summary. To date all I have been able to do is task level / individual project level % complete thanks!
