-
Proofs disappeared
This discussion was created from comments split from: Why are my proofs disappearing!.
-
Can I migrate from a eu region acctoun to an us region account? (wrong account and paid creation)
Can I migrate from a eu region acctoun to an us region account? (wrong account and paid creation)
-
Feed line from one sheet into another multiple times, assigning a different task to each new line
Hello! I have a master sheet where I keep track of all of our companies' giveaways we offer. It has a lot of checkbox columns to identify which tasks have been done and which have not. Currently I have automated reminders set up that send me an email to tell me something needs done. However, that A LOT of emails, and I…
-
Smartsheet Python API clear images from a range of cells
i'm currently using smartsheet python API and have managed to create a script that from a given range of rows (for example row 4 to row 20), for the 10 first columns, it deletes all the contents. It is working perfectly, however it only deletes all the string contents, but the images still remain. the images were attached…
-
Report for Automation Workflows that are active
I have hundreds of workflows for our company. When someone joins the company that needs to be added to workflows or when someone leaves the company that needs to be removed (currently when the user is deleted from our account it does not remove them from any workflows), it's very hard to keep up with all workflows that…
-
How can i use IF, AND in a date formuls?
I currently have a formula that looks at a column called "Week #" and takes the entry and converts it to a date that represents the first monday of the corresponding week. This helps me plan work a number of weeks out. the problem is that as i get towards the end of the year, i need the date produced to show the week for…
-
Auto Save a Sheet and Auto Refresh
Can the auto save be set on a specific sheet? Or is it only available on the individual user levels? I have a sheet that multiple people access. I have my personal autosave set at 1 minute but other users on the sheet are having issues of stuff not saving when the auto refresh runs. Additional question…with auto refresh…
-
identifying a duplicate entry
hello, Im looking for a formula to red flag all the duplicates entry in a previous column. Above an image that what can im looking for, thanks Im put the red flag manually for show you.
-
Can someone help with a formulas COUNTIF
I'm trying to write a formulas for the following situation. Sheet 1 has a column A. Sheet 2 has Column A (same with column A from sheet 1) and Column B, Column C. I want to search the value from sheet 1 Column A in sheet 2 column A and count the non zero values from column B. Thank you
-
How do i use IF and CONTAINS properly?
Im truing to write a formula that searches another sheet to see if one column has a cell that contains the same PO # and glass type. If yes, i would the box to be checked. If no the box should remain unchecked. Any ideas? Below is what my formula currently looks like: =IF(CONTAINS([PO #]@row , {Glass Inventory Intake /…