-
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?
-
How to concatenate two functions in a single cell
I want to concatenate two functions in a single cell and populate the values in the same cell separated by coma.In excel we do the same by =H65-K65 &","& I65-L65 but in smartsheet when I try the same like =[Next month Proposed date for First]2 - [Assigned date of First PCT after Finetuning]2 &","& [Second PCT]2-[Assigned…
-
User Email to update status in smartsheet
Dear Smartsheet users, can I use an email to update a status? We create a ticket in Smartsheet - then we send it to a ticket system. A status update will be provided back to smartsheet and should update the status from new to done. All I found was just creating a new entry in a sheet upon email entry. Regards, Christian
