-
Integration with Smartsheet Projects
I have a process with which I create a project in Smartsheet, one of the sheets in my project is a resource sheet. So I add the resource names and create a Resource Management project in RM for the project. I would like to add a flag in Smartsheet that indicates (green) if I have an associated RM project or (red) if I do…
-
Current Date + 6 months
Hello, I'm trying to figure out how to designate (highlighting or change text color) a Project that has an end date of 6 months from the current date within a grid. Here's an example grid. I figured out conditional formatting using a certain number of days but is there a way to do a specific number of months? Thank you.
-
DATE Function
I am wanting to count how many open and on-hold calls I have open over a month using the date function. I have 2 Columns as helpers "SD" & "ED" SD is static and selects the first date via the Calendar and ED which gets the last date using the SD column ED -Formula: =IFERROR(DATE(YEAR(SD@row), MONTH(SD@row) + 1, 1),…
-
Count and Lookup - based
Experts, I need to count the values of each column excluding Today Value. Rest of the Yesterday and Blank values of respective columns like #New Hires, and drop the values in the 2 Yesterday Metrics. It is pretty easy to do a vlookup for Today, but if I need to cumulate the Yesterday and Previous day values. How do i do…
-
Use dependencies to set start and end dates independently
how can i use dependencies to help set both a tasks start AND end date independently (not using duration)? As an example, i would like row 3 start date to be row 2 start + 5 (I can get that by setting predecessor = 2SS+5), but I want row 3 end date to autopopulate with row 4 start date.
-
CTRL+e for details conflicts with Chrome Browser shortcut / hotkey
Typing CTRL-e in the Chrome Browser opens a Google Search in the address bar instead of showing the details view in Smartsheet as intended. Can you think of any way around this conflict?
-
Philippine Mobile Number
Please add mobile number input for Philippine region. Currently, we're doing a workaround where we only allow numbers to a field in a form, but it's unintuitive. Our country code is "+63" Thanks
-
Count if Formula to retrieve multiple criteria
Hello Experts, I am looking for a formula to count all of the New Hires from Yesterday/Today column using Previous Days and Yesterday values.
-
Smartsheet Integration for Slack
Hello, I've integrated Smartsheets to my slack and see the icon under my apps. However, when I create a workflow and select "alert in slack channel" it shows public org channels instead of the one that I created. I would like notifications to only go to a few folks on the team, so I created a public and a private channel…
-
Image upload to multiple cells through API integration
Hi everyone 👋 I developed a Python-based application that enables uploading images directly to cells (instead of row attachments), allowing for more structured and visually organized data within sheets. Key highlights: Upload images directly to specific cells Built using Python and Smartsheet API Designed for structured,…