-
Button to add text to pictures is missing in Android app
Hi, According to the following help article there should be a button to add text to pictures when uploading pictures with the Android app. This button is missing in the app on my phone and on my tablet. I updated both devices to Version 9.3.0 Build 323. Is it possible to solve this? Screenshot from the article: Screenshot…
-
Can you block users from adding new lines after a certain number?
We are using a sheet to track candidates for a position. We need X number of candidates to Y positions. We're using a formatting trick to show when the target number has been exceeded but it would be nice to be able to limit the number. Users would still need to edit the existing candidates.
-
Indirect style look up from another sheet
Hello, I am trying to access data from another sheet using a reference to another column within the row using a sum formula usually in excel I would create a =indirect() reference, how could I replicate something like that within smartsheet.
-
Copying rows to the top of a sheet (Automation)
Hi Everyone, This question was asked before but I have not found an answer. So asking again to see if there is any new development which I have missed. I have set up an automation to copy rows from each project sheet to a master sheet (based on some trigger). The row for the first project was copied arbitrarily in the…
-
Autocomplete data entry like Excel
I simply want to have Smartsheet autocomplete my data as I enter it in a cell as Excel does. Is there a way to turn this on?
-
Is there a work around for trying to use CONTAINS() or HAS() within collect()?
I am trying to summarize my projects data that is assigned to a work type, dates/weeks specifically and then count it by week or singe day. Can't figure it out. I have a summary sheet that brings in a multi select column (I have also tried it just text) off all the dates each work type has work. I am then on a separate…
-
How can I count distinct values under a same month?
Hi everyone, I currently have a data set for which I would like to count all unique values that are under a same month and a same year. For example, the following table shows two duplicate values (TR ID's) on two different dates. In this case I would only like to count the unique TR ID's for the month of August, 2020…
-
Indenting on smartsheet causing calculation error- help?
Hello, My organization uses smartsheet as a scheduling tool. We have a column that calculates what resource hours we have remaining for available scheduling (formula =((# of crew members * work days * work hours) - SUM(CHILDREN())) in my case specifically, =((8 * 5 * 7) - SUM(CHILDREN())) ) If a work order has multiple…
-
Need to Tally and List Unique Values From a Drop-Down
Hello, I have a sheet in which I am tracking distributor complaints. I need to make a few different graphs. One of which is supposed to be a line/tally graph of how many complaints have been made by each distributor. We have a list of almost 40 different distributors which we have in a drop-down select form, for the ease…
-
Is there such a thing as COINTAINSIF?
Which function do I use to count the number of times certain letters eg PRJ and TRN appear in a range if in another column the project is open (not closed).