-
OTP Screenshot Request
Greetings - Does anyone have a screenshot of what the TOTP logon screen looks like? I am writing some documentation and would like to provide a screenshot. A screenshot of a sample pass code email would also be useful. Of course, redact/blur out any of your organization's identifying information. Much appreciated! Karla
-
Need Account Names for Contractor License
My contractors work many clients for us at the same time. They can't see where to post their time. Make this ability optional pls.
-
Exporting a Report into Excel with Formatting
I have gone in circles trying to figure this out, and I haven't gotten a solution, but is there a way to export a report in Smartsheet and keep my formatting? I know I can export and create a pivot table, but I was wondering if there was a different way around it.
-
Create a date column that can tell me the date that cells in another column last changed
I need to be able to create a date column that can tell me the date that cells in another column last changed. Could be a column type or a formula I don't have any way of ageing a data set at scale. I can look at individual cell history, but I need to date all cells in a column and sort or filter by age.
-
Problems creating a chart for quarterly metrics
Hope everyone is enjoying their day! I would appreciate any assistance with my issue. This is report that needs to be charted: Here is how the chart comes out: How do I get it to show actual quarters and their numbers? Thank you in advance for your time and effort.
-
Cross reference another sheet and filter the criteria
Looking for a formula to pull data from another sheet and add 2 filter criteria. Here is my filter critera but not sure how to reference the source smartsheet. =COUNTIFS([Client Mitigation Status]:[Client Mitigation Status], "Pending") + COUNTIFS(SBG:SBG, "AERO")
-
Link or Attach Google Drive file/asset in column
Is it possible to link to Google Drive files and have them appear in a designated column? I see that you can attach them to rows, but they don't really "appear" anywhere other than the little icon at the beginning of each row. For example, I want to have an "assets" column on my sheet and have all related files from my…
-
Clarification regarding Average(collect)?
I'm trying to calculate the average lifespan for a specific machine in a specific area, but am running into an issue with my average(collect) formula. Here's the formula I have right now, and it only returns as unparseable. =AVERAGE(COLLECT({Lifespan},{Machine},"1",{Row},"1",{Position},"1")) In this instance, its to…
-
Alert Someone Automation Workflow
Hi, I have column in a sheet named "Interests" with a dropdown with multi-select. So based on this dropdown, I'm looking to creating a workflow, to send automated email alerts (based on dropdown selection), however I am not able to select the dropdown values within the automation as shown below in the screenshot. I wanted…
-
Date filter not in effect when I reference a Sheet. And, COUNTIFS/CONTAINS issue
I am trying to pull info into a helper sheet from another sheet that I have filtered to only have items with a completed date in 2024. When I then insert the reference to that filtered sheet it is not showing just the filtered items I want, but dates going back to 2020. Is there a fix for that? Once that is fixed, I would…