-
📢 ENGAGE User Group Session - Sign up today!
Exciting news, Smartsheet Community! At ENGAGE, we'll host a User Group session on Monday, Oct 7 from 3:30-5:00 PM PT for all attendees. Join us to network, learn from other users, and pick up helpful Smartsheet tips. If you're registered for ENGAGE, add the session to your agenda using the link below! 🎟️ Monday, Oct 7…
-
Need help with Countif date formula
I have a date column, and I want to count the number of "Good Rolls" for that specific date. I managed to get Shift LBS Produced for the 24th and Total Rolls. The number 81 in good rolls column reflects the total for all date. How do I get a result for just the 24th, 25th etc.
-
Changing Email - How to?
Hello, I am changing my email address due to a new last name. I see that there is a way to add and email address in to your profile as an addition where smartsheet would recognize both. My question is, can I adjust the primary and delete the old email address from my profile? I assume the primary would be the one all the…
-
ability to send generated documents to people who don't have access to the sheet.
It would be helpful to be able to send generated documents (or even just specific attachments to a row) to people via automation email without giving them access to the sheet.
-
Superscript and Subscript format
As I was transcribing some data from Excel today, I was surprised when all my superscripts became normal text in Grid. As far as I can tell, there is no way to superscript or subscript data in Grid or Dashboard. These are common and sometimes critical format properties. Useful for, among other things: Chemical Formulas…
-
Formula
Hi all, I am trying to combine the following two formulas, only one works at a time. =IF([Variance (Target End date)]@row = 0, "Green", IF([Variance (Target End date)]@row <= -4, "Red", IF(OR([Variance (Target End date)]@row = -1, [Variance (Target End date)]@row = -2, [Variance (Target End date)]@row = -3), "Yellow",…
-
If and formula help
Trying to create the below formula but its coming up with unparseable… =IF(AND(Performance@row <2, Trust@row <2), "C1", =IF(AND(Performance@row <2, Trust@row = >2 <3), "C2", =IF(AND(Performance@row <2, Trust@row = >3 <4), "C3", =IF(AND(Performance@row <2, Trust@row = >4 <5), "B10", =IF(AND(Performance@row <2, Trust@row =…
-
How come I can't delete a scheduled report?
Every time I click the down carrot next to the scheduled report and hover over Delete it won't turn gray so that I can select it. Ultimately, I can't delete the report. Please help. This gets emailed to a host of folks. Thanks!!!
-
How do I remove just one person from receiving automated email reminders?
Hello! I have a colleague that no longer would like to receive the automated reminders only for a specific sheet. How do I remove them from the reminders without ended the reminders for everyone? I was not the one that set up the reminders. Thank you in advance!
-
How to start a new calendar using the calendar app
I am creating a new calendar using the calendar app. I have looked online and seen there should be an Add New button. But mine isn't showing that? Do I need anything to have the button? I have a full license.
-
Sharing Report
Good Morning, Wanted to see if someone knew the best way to share a single report to an individual. For some reason when I attempt to share to individuals they normally respond that they are denied access due to permission. I have published the item and sent the published link to them with the box selected that indicates…
-
Making a Gantt View with only working days (Mon to Fri, exclude public holiday)
Is there a way to remove weekend and public holidays from Gantt chart? I'm planning a project with long durations per milestone, I would like to see only working days in the columns; alternately, can I have the duration formula only calculate # of working days?
-
自分のライセンスを確認できるページがありますか。
こんにちは。Smartsheet管理者以外にユーザーがライセンスユーザーなのか一般ユーザーなのか確認できるページが無いようです。自分もしくは他ユーザーのライセンス有無を確認する方法はないでしょうか。
-
How to add a time stamp when a status is changed?
In the Sheet change there's a Record the date when specified criteria are met and is there one for Time? Or is there a formula to capture when specified criteria are met the adds a time stamp?
-
Easy Way to Link Multiple Cells to Different Sheets?
I currently use a 'summary sheet' which is used to track different dates from different smartsheets. Basically, we have it written horizontally so each sheet/job has it's own row within this sheet and the columns are used to track different milestone dates from these different sheets. Typically, we just have to link cells…
-
Dashboard Help
I want my dashboard to track a couple of things. First the total number of yes and no's in this sheet (form dumps into it). Then I want it to track the "What info is missing" part and a count for how many for each monthly. I want it to look something like this but with each individual question in "What info is missing" to…
-
If a sheet was created, and the person is no longer employed, can we still get access to the sheet?
How would one go about getting access to a sheet/form if the person that created it is no longer employed?
-
Links to Sheet and Specific Fields in Workflows
Hello, I am setting up a basic automation workflow. I have selected the option: "Message includes: Link to Sheet and Specific Field". When I test ran the workflow, I received the email but I thought the specific field I included would be a link directly to that field. Instead the only link was at the top ("Sheet Name"),…
-
Hola es posible que en el mail de alerta se detallen mas de 100 lineas?
Necesito enviar informacion a varios destinatarios sin que puedan ingresar a la planilla, ya que hay informacion cruzada que no deben acceder. el problema es que la info en algunos casos es de mas de 100 lineas y en el mail no se muestra. Gracias Juan
-
Dynamic View Current User
Dynamic View sharing is set to our domain. Users will have email address in our domain. Users will NOT have Smartsheet account. Is a Smartsheet account required for "Current User" View to work? Will it capture the Current User's email in created/modified by? We have >100 people that do not require Smartsheet for their…