-
Is there a maxium number of characters for the gantt bar label?
Hi anyone, I have a custom Gannt bar label set using the gantt timescale settings from a helper column that concatenates some information about that task. This can get quite long, especially if the project name is long, and I'm finding some labels cut off. Is there a maximum length (it seems to be 73?) or am I missing…
-
COUNTIF and CONTAINS function
Looking for help as to why the below formula isnt working: =COUNTIFS({Intake - Project Customer Satisfaction Sur Range 7}, "Professional Services", {Intake - Project Customer Satisfaction Sur Range 6}, CONTAINS([Primary Column]@row, @cell)) Let me know if you need any additional info. Thanks
-
Add a excel data sheet to an existing Smart sheet data base.
Hi, I have an existing database on smart sheet that I used for my MailChimp campaign. I now have the results of this campaign (who opened, who clicked) : I extracted the data from Mailchimp into excel. I would like to import/ merge that excel data into my existing Smart sheet. How do I do this ? Thanks for your help
-
Cross sheet countifs, multipul drop down in cell - multipul errors.
Hi All. I run the current cross sheet formula which is working when there is only One request type seleced in the cell. ie; Costing. When there is Two in the cell ie, Costing Drawing the results is not counted. I have tried changing COUNTIFS with COUNTM however this results in a count of 177, rep in question only has 13…
-
Data import from gSheet to SmartSheet via a Connector
Hi all, I need support in connecting date from gsheet to smartsheet. I am having two files: gsheet including rates per employee smartsheet (where I would like to import the individual rates per employee from the gsheet) I am having one connector in both sheets: individual resource ID (per individual employee) Which formula…
-
Reset Value to 0, No negative numbers
Is it possible to have a number go down the 0, but not have it have a negative value? I'll share my sheets to illustrate. So this is my current sheet. I am running into an issue where people are having a negative total (picking up a ton of OT shifts) and they accumulate a big negative total value, so when they do no-calls,…
-
Why does my simple flow not working ?
I have created a simple flow that whenever an input is reached the sheet through a form, an email has to be triggered to the sender as an acknowledgement. This was working for some time and now this is completely stopped working. It doesn’t respond event when i trigger this manually from the workflow screen.. Any idea?
-
COUNTIF Formula for Multiple Statues and Conditions
Hi, I'm struggling to have a working formula that would meet the conditions I am trying to have shown. The 6 statuses are: Not Started, In Progress, Completed, Cancelled, On Hold, Delayed So here's the logic I'm trying to apply: If all children are Not Started, the parent is Not Started If all children are In Progress, the…
-
Today() Function not updating
Has anyone else noticed that the today function is no longer updating consistently when sheets are triggered through either cross sheet references or through an automation that records todays date. I have used these procedures successfully for years but in the recent weeks they have stopped working. I can't go back and…
-
PLEASE HELP! formula to calculate % of completeness between two dates
Hi All! I am looking for help with a formula to calculate % of completeness between two dates in my sheet. After inputting the formula, I am getting the #INVALIDDATATYPE. I have checked that all of my columns are date-assigned. Can someone please help me? Here is the formula that I am using with a screenshot of my sheet.…