-
cross-sheet duplicate search
Thanks in advance for reading this :) I have multiple inventory sheets, each has a column with a formula to flag duplicates within a specific column: =IF(ISBLANK([Serial Number]1), "blank", IF(COUNTIF([Serial Number]:[Serial Number], [Serial Number]1) > 1, "yes", "no")) Form there, I apply some simple conditional…
-
Use a form to lookup sheet data that and add content to it
Hello, I have read the forms with the “VLOOKUP” and “LOOKUP” functions. I am new to smart sheet, but not to excel formulas. I have an associate inspecting carts for wear and tear items, this is working well with check boxes and the photo attachment is awesome to have. Next step is the associate that repairs the cart, I…
-
Percentages are showing minus numbers -120%
hello all, my percentages are going int minus or over 100% . i currently use this formula , can anyone help =(TODAY() - [Start Date]5) / ([End Date]5 - [Start Date]5) regards Carl
-
Impact with Urgency equals Priority
Hi, I am looking into utilizing a ITIL related priority matrix approach to populate a Priority. The Priority levels column's cell would have values P1, P2, P3, P4, P5. The formula needed in the Priority column would output an appropriate priority level based on specified combination of values from two other columns: Impact…
-
Reports Published To A Site
I have a report that I have published to a dashboard/site. I need the users to be able click on the Widget in the site to open the report, mainly so they can view comments on the rows in the reports. I need them to be able to do this without them being granted access to the source sheets. Any assistance or direction on…
-
keyboard short for inserting comment
First post. Love Smartsheet! Did some searching, but came up blank.... I'm typing away managing my first big project in Smartsheet and am adding a lot of comments. I'm clicking the mouse to bring up the Comments dialog. At least I can <TAB><SPACE> to tab to the post button. You're already doing better than google in terms…
-
UK Contact - Issue with account
Hi, does anyone have a contact number in the UK that works? my account & my whole company is locked out & asked to upgrade when we already have.... this is very urgent!!!
-
Populate Start/End Date based on Status change
I use the Card View for quickly creating tasks and tracking their status/state. I'm trying to see if it's possible to take this further and populate the Start Date and End Date fields when the task first enters a specific state. See screenshot attached.
-
Dynamic Template
I want to create something that is several columns containing data is is continually updated - but only added to, no content is ever deleted. I'm calling this the "template". I'd like to be able to pull the "template data" exactly as it is - format, parent/children, text, etc AND as it changes into other sheets so that…
-
"Dashboards just got better"
Has anyone had any success creating a chart with nonadjacent columns following the recent communication that the charts have more options?
