-
Formula to return the logged in user
Hello, Is there any formula to post(return) the name of the logged in user? I am trying to record the user name of the person who checked a box. for example, If I want to post a date when a box was checked, I write: =IF(Closed1 = 1, TODAY(), "")can we have something like =IF(Closed1 = 1, Logged user, "") I know that there…
-
Is it possible to have a column in a sheet serve as a reference to multiple other sheets?
Here is my scenario: I am redesigning some of my template sets and dashboards but leaving the originals up and running at the same time. I created a sandbox environment (workspace) to do this in. Some of the new sheets use the same data and formulas. Copy and pasting the formulas sometimes required me to recreate the…
-
Data Uploader Filtering
Hi All, Just a quick question regards the filtering in Data Uploader. I'd like to look at everything incoming from the report I pull for the last 30 days. Having already mapped the columns, I'm just wondering what would the correct formula criteria be. Incoming equals TODAY()-30 - or something similar? Screenshot attached.…
-
vlookup of image
Hi, Im Senando Benig Jr, Just Sen for short, Im in manila Philippines, My company start smartsheet from scratch and im the one assigned to develop an application. I explore smartsheet for more than 1 year and i think im in advance now. My concern is , is there anyway to vlookup and image? because when i try to vlookup it…
-
Need help with using a COUNTIFS with OR
Hi, I'm trying to create a nested formula used in a ticketing system that will total up active status (Open or In Progress) compared to location. Ticket Active Status for Location = Location <and> Status [Open <or> In Progress] My Status column is using RYG balls, so "Red"=Open and "Yellow"=In Progress. I keep getting…
-
Form Submission
If I create a form in smartsheet and someone were to complete the form, can I make it so that multiple people can be notified about the form submission and have access to the information submitted? If so, how do I do that? Can this be done automatically without me having to check daily and send notification via email…
-
Adding Formulas to Predecessors Column...Or Is there a Workaround?
Hi there, Okay, so here's what I'm trying to do. Our team is using a smartsheet schedule and within that schedule, is a bunch of sub-schedules, that all work together in glorious harmony :) Up until now, I've been able to use the Predecessors column with ease, for e.g. 1FS + 5d, meaning that the project on the 2nd row will…
-
Highest value on the last six values of data
I'm looking to find a formula that will capture the last six months of data and then return the highest value within those six values. On excel, I've used, for example, MAX(OFFSET(B3,COUNTA(B3:B113)-6,0,6,1)) but I see "offset" is not compatible with smartsheet. I don't believe Index and Match would work with what I'm…
-
Webinar: A 2020 View of IT PMO Trends, Best Practices, and Technology
In this webinar, you'll hear from Andy Jordan, President at Roffensian Consulting, Greg Alexander, Director of Project Management at Citrix, and Rajiv Arunkundram, Senior Director of Product Management at Smartsheet. Together they present how IT PMO leaders and practitioners are leveraging the latest in technology to…
-
There´s a way to copy a row to another sheet with a if formula?
Hi everyone, i have a group of four sheets and i want to copy specific rows to another sheet. I have a column called "FORMAL RECLAMACIÓN" and i want to copy the entire row to another sheet if there´s a date on this column. Is this possible?
